View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Calculate hours between to separate dates and times

Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
--
__________________________________
HTH

Bob

"Dave08" wrote in message
...
I need to work out the amount of hours between a finish time on one day and
the start time on the next day. In some cases the start time may not be
until
2 days time.