View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevo Kevo is offline
external usenet poster
 
Posts: 5
Default Excel 2007 calculate time between 2 date/time columns

I am using Excel 2007 and trying to calculate the actual time it takes to
pick orders.
Work day starts at 06:00 and ends at 20:00. using simple [end time] -
[start time] calulation. How do i calculate the hours if the job goes in to
the next day? I am a novice, as you can tell, but desperate to learn.
Kevo