Thread
:
How do I extract time only in Excel?
View Single Post
#
2
Posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,768
How do I extract time only in Excel?
One way:
A1 = 6/25/2008 12:05 AM
=MOD(A1,1)
Format as TIME
--
Biff
Microsoft Excel MVP
"grant" wrote in message
...
How do I extract time only from a date/time cell in Excel?
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko