Hello,
I'm currently using a schedule template for the workplace. Since I did not create this template myself I'm not 100% on all of the formulas used. My issue with the template is that in my "Total" column the total hours for each employee is calculated with a 1/2 hour break. I don't want the Total time to be calculated with Breaks.
The current Formula being used is:
=SUM(Sheet2!I1:O1)
=SUM(Sheet2!I2:O2) ... and so on
My Setups is...
Monday Tuesday ... Total...
6:00a 2:00p 6:00a 2:00p 15
I have attempted using basic SUM formulas such as:
=(I7-H7)+(O7-N7)+(M7-L7)+(K7-J7)
This formula works to add the hours up, but it goes up to 24 then resets and counts back up from 0. This is obviously because there are 24hours in a day. If I could find out how to fix either one of these issues my template would work perfectly.
I'm using Excel 2007.
Thank You, for your time
John
Bookmarks