Thread: find the difference between start time and end time when spanning.
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default find the difference between start time and end time when spanning.
If you have start and end times in Excel date and time (formatted in your
example as h:mm AM/PM dddd), then you can just use =B2-A2, and format the
result as [h]:mm to show a time beyond 24 hours.
--
David Biddulph

"wahoos" wrote in message
...
I'm trying to find the difference between start time and end time when the
total time will exceed a 24 hour period.

10:00 PM Friday 3:00 AM Sun


Reply With QuoteReply With Quote