I am using an excel template to log my regular work hours, the hours I work
"overtime", and hours that I use to cover missed days from my "Overtime"
hours. What I have been trying to create, is a spreadsheet that will
automatically log the number of hours I work "overtime" from each spreadsheet
in this workbook (since each spreadsheet is one week's timecard) and subtract
any hours I use from those "overtime" hours to cover my missed days.

I have been subtracting and adding the hours up in a spreadsheet I created
previously, but I would like Excel to do this calculation for me, so I cannot
use hours I don't really have by accident.

Can anyone help?!

As you don't give any detail of your data, I'll guess!

Overtime: = MAX(0,Hoursworked-non_OT hours)

where non_OT hours is the standard working week (40 hours say).

If you need further help, supply details of your data/calculations.

"MsSnowy" wrote:

I am using an excel template to log my regular work hours, the hours I work
"overtime", and hours that I use to cover missed days from my "Overtime"
hours. What I have been trying to create, is a spreadsheet that will
automatically log the number of hours I work "overtime" from each spreadsheet
in this workbook (since each spreadsheet is one week's timecard) and subtract
any hours I use from those "overtime" hours to cover my missed days.

I have been subtracting and adding the hours up in a spreadsheet I created
previously, but I would like Excel to do this calculation for me, so I cannot
use hours I don't really have by accident.

Can anyone help?!

I guess what i need to know is how to reference a cell in a different
spreadsheet, where the formula is smart enough to refer to each new
spreadsheet I create off of the initial template, for example:

The Orginial Timesheet,
1. Calculates my Total Hrs (In column G) worked with this formula:
"=((C14-B14)*24)+((F14-E14)*24)+I14"
2. Calculates my Regular Working hours (In column H) with this formula:
"=IF(((C14-B14)*24)+((F14-E14)*24)8,8,((C14-B14)*24)+((F14-E14)*24))"
3. Records the number of hours (In column L) OVER my regular amount I've
worked, that I need to log: "=IF(G148,G14-H14-I14,0)"
4. Columns B-F allow you to enter the time of the day you clocked in and out.

This Original Timesheet template has been repeated each week.

What I need is to know how to get in a seperate spreadsheet, that's still in
the same workbook, to automatically calculate the amount of time I've worked
overtime for each and every week, as well as subtracting the amount of hours
I use from those towards days when I need to cover for missing hours.

Do you understand what I'm trying to say?

"Toppers" wrote:

As you don't give any detail of your data, I'll guess!

Overtime: = MAX(0,Hoursworked-non_OT hours)

where non_OT hours is the standard working week (40 hours say).

If you need further help, supply details of your data/calculations.

"MsSnowy" wrote:

I am using an excel template to log my regular work hours, the hours I work
"overtime", and hours that I use to cover missed days from my "Overtime"
hours. What I have been trying to create, is a spreadsheet that will
automatically log the number of hours I work "overtime" from each spreadsheet
in this workbook (since each spreadsheet is one week's timecard) and subtract
any hours I use from those "overtime" hours to cover my missed days.

I have been subtracting and adding the hours up in a spreadsheet I created
previously, but I would like Excel to do this calculation for me, so I cannot
use hours I don't really have by accident.

Can anyone help?!