TimeSheet

[superwiki]

I am creating a timesheet for my office, but have hit a wall with calculating overtime.

Currently, I have a final hours cell showing in cell A1 with total hours as 52:00:00 as 52 hours worked. When I try to use a formula in cell a2 to calculate overtime like =sum(A1-40) to get 12 hours of overtime, it just returns the ###### symbols.

Anyone??

Thank you in advance.

[shg]

In Excel, dates are whole numbers (days elapsed sinc 0 Jan 1900) and times are the fractional parts. So =A1-40/24

[superwiki]

Thanks for such a fast response. Unfortunatley, im still getting the ##### response in the column. If I take it off custom cell, the number is -1.67 I believe.

I have a weekly running total of hours in column AR7. Right now that persons hours in that cell show 52:00:00. I would like cell AS7 to show 12:00:00 or even the number 12 as the right number of 12 hours overtime worked.

Thanks a ton!

[shg]

Post a workbook.

[superwiki]

Here is a barebones copy of the workbook. I would like cell ar7 to reflect just 40 hours of work and the cell next to it, AS7, to reflect the overtime hours. Even if I could just have the overtime column work would be something, but whatever I do, it doesnt calculate the hours at all. thank you in advance for the help! much much appreciated.

[G0liath02]

Once you start on calculations you'll have less trouble with calculations if you convert the time into a number format.You do this by *24. Here's your formula - make sure to format the cell as a number or general type.

=IF(($AR6*24)<40,0,($AR6*24)-40)

[DonkeyOte]

I would suggest:

=MAX(0,AR6-"40:00")

The answer would be 12:00

[superwiki]

Thanks a ton guys, excellent help. What a great forum to be a part of. Hopefully, as I become more proficient with Excel, I too will be able to help others.

Thank You