Thread: Extracting time (hr:min) from date/time format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
barry houdini[_19_] barry houdini[_19_] is offline
external usenet poster
  
Posts: 1
Default Extracting time (hr:min) from date/time format

If you have a time/date in C2 you can get the time only by using this
formula

=MOD(C2,1)

.....but what result do you expect from your data? The 2nd line has 2
different dates, don't you want to take the dates into account when
calculating the difference?


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126433

Reply With QuoteReply With Quote