ExcelBanter - Formula used to calculate daily employment hours ...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula used to calculate daily employment hours ... (https://www.excelbanter.com/excel-worksheet-functions/32519-formula-used-calculate-daily-employment-hours.html)

DarDarren

Formula used to calculate daily employment hours ...

Excel version 2003...I need to calculate overtime hours....how do you
differentiate between AM PM....how do you caluculate when hours run from one
day to the next
ex. 11:00pm - 2:00Am the following day

Dave Peterson

Another option may be to enter both the date and time.

DarDarren wrote:

Excel version 2003...I need to calculate overtime hours....how do you
differentiate between AM PM....how do you caluculate when hours run from one
day to the next
ex. 11:00pm - 2:00Am the following day

--

Dave Peterson

All times are GMT +1. The time now is 08:59 AM.