Schedule Template Assistance

[Joneill143]

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

[alansidman]

It would be helpful if you could post your spreadsheet with some sample data. We can then see the whole issue

Alan

[Joneill143]

Sorry for the time between getting back.

I attached the file I'm using with some numbers input. It should be easy to see that all scheduled hours are affected by break times. I'm more then willing to create a new formula for calculating the hours for each individual if it solves the issues.