Thread: Time difference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aliya.pawaskar[_2_] aliya.pawaskar[_2_] is offline
external usenet poster
 
Posts: 6
Default Time difference

Hi,

I am doing a time and motion study and we have 2 columns Start Time and End
Time. the third column is the Time difference for the Start Time and End Time.
My problem arise when the day changes, i.e. We work night shifts and if we
start something before 12:00 AM and ends after 12:00 AM, the difference
column does not give me result.
Can somebody please help?

Thanks,
Aliya