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.

=TIME(HOUR(C1),MINUTE(C1),SECOND(C1))

Example:





Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts