Posts Thursday December 21, 2017Registration date
January 4, 2018
Dec 26, 2017 at 04:31 AM - Latest reply: ac3mark9225
Posts Monday June 3, 2013Registration dateModeratorStatus
April 26, 2018
- Jan 4, 2018 at 05:15 PM
Hello CCM community!, Here I am again with a question that's being bugging me for a while
A while ago I created my own version of a work scheduler that will calculate hours worked and also would take breaks off the worked hours depending on the length of the shifts.
This was all good for regular shifts but when we started having overnight shifts I couldn't just calculate the difference between punch out and punch in times.
The spreadsheet had 2 cells per day, clock in and clock out per day, and at the end of the week I had this:
A column were the names of employees,
B-C were Monday, D-E were Tuesday and so on until you reach P which had this formula:
However, it was easy to calculate that using a 24H format, but when the shift ends past midnight I can't put 01:00 - 23:00 without having a negative number therefore the time totals won't be accurate.
Clock in 18:00 Clock out 01:30
Here are my questions:
How can I edit the second cell to accept that deleting a clock out time after midnight will calculate the time worked?
My worked around was to add 24 to the end time, I.E. 26:30 was 02:30am But when printing the schedule, the clock out times are not real life time and will cause confusion on whoever reads the schedule.