View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mailrail mailrail is offline
external usenet poster
 
Posts: 28
Default Calculating time past midnight.

I'm trying to write a formula that will calculate my employees' total time
worked. A problem arises when I have people scheduled to work past midnight.
If, say, someone works from 9 pm until 3 am, how do I get Excel to recognize
the change in dates and properly figure the time?