ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Time and date calculations (https://www.excelbanter.com/excel-worksheet-functions/14440-time-date-calculations.html)

Bob

Time and date calculations
 
I need to calculate the total overall time a person worked. This may overlap
two or three days.

i need to make sure that they get at least an 8 hour break between work
periods also.

Is there a calcuation that would do that for me?

Thanks in advance
--
bob

Peo Sjoblom

Try to adapt this

http://www.cpearson.com/excel/DateTimeWS.htm


--

Regards,

Peo Sjoblom


"Bob" wrote in message
...
I need to calculate the total overall time a person worked. This may

overlap
two or three days.

i need to make sure that they get at least an 8 hour break between work
periods also.

Is there a calcuation that would do that for me?

Thanks in advance
--
bob





All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com