Wednesday, 15 August 2012

How to get Time value from a cell having Date and Time

Get Time value from a cell having 'Date and Time' in Excel
Suppose cell A2 have a date and time , from that if you want only Time in B2 then simply use the following formula.




No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts