Time calculations

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Excel 2003

I want to try to put together a store employee schedule for my son and I am
wondering what is the best way to deal with time calculations.
they do not use a 24 hour format so how can I do calculation (shift times,
Employee availability times, sum of hours......) when the times are AM/PM
format.
Any guidance here will be appreciated.

Thanks

dave
 
You can add and subtract times irrespective of the format. 17:00 less 08:00
returns 9:00 the same as 5:00 PM less 8:00 AM returns 9:00.

You will need to use the number format to format answers correctly. When
summing hours that exceed 24:00 then use custom format [h]:mm so that it
remains in hours and minutes otherwise Excel thinks it is the next day.
Example 12:00 + 13:00 is 25:00 but Excel will attempt to display it as 1:00
AM. Using the square brackets around the h displays as 25:00.
 
Back
Top