Thread
:
extract time from excel serial date
View Single Post
#
1
Posted to microsoft.public.excel.programming
Dan W[_2_]
external usenet poster
Posts: 3
extract time from excel serial date
Hi all
Is there a way(VBA or function/formula) to extract the time from a serial
date in excel?
i.e. date in cell is 38140.7291666667 (6/2/2004 5:30 pm)
and want to extract time only
Thanks in advance
DW
Reply With Quote
Dan W[_2_]
View Public Profile
Find all posts by Dan W[_2_]