overtime on timesheet

[kimmyrt]

I've posted this problem twice already and the next day my post disapears, so
hoprefully this time it will stay. Anyway, I hope I can explain my problem
ok, I need a formula to put in so that I can just input the hrs. and the
time worked over or under 40 hrs. a week will come up. Also, I need one for
a running total of hrs. worked over or under 40 hrs. a week. This is an
example of what my timesheet looks like:
A= Name
B= Work period (one week)
C= hrs. worked (in one week)
D= hrs. short or over 40 hrs.
E= running total of hrs short or over 40 hrs.
Basically, the timesheet is just one long excel worksheet with each week and
the hrs. on it.
So basically, I just need a formula for columns D and E.
If this doesn't make sense and you have an idea of what to do, just let me
know and I can send you a copy of the timesheet, it's really small.
Thanks so much in advance for the help!

 

[Peo Sjoblom]

Don't know if you will be able to see this but you already gotten several
asnwers and offers of emailing you example, you can search your own signature
here

http://groups.google.co.uk/groups?hl=en&lr=&group=microsoft.public.excel

you can download a workbook here

http://www.cpearson.com/excel/overtime.htm


Regards,

Peo Sjoblom

 

[IC]

Assuming headers in row 1 and data starting row 2:

In D2: =C2-B2
In E2: =SUM(C$2:C2)-SUM(B$2:B2)

Copy these formulae down the columns.

Ian

 

[kimmyrt]

Thanks, I'm just gonna look through google, at least I can see my posts. I
wonder why I couldn't see them here. Oh well. Anyway, those formulas both
gave me errors. Dont know why.

 

[Peo Sjoblom]

Although the formula had nothing to do with overtime if they give you errors
you might have text values instead of numeric time values,

=ISTEXT(A1)

will retrun TRUE if that particular cell is text


Regards,

Peo Sjoblom

 

[Gilbert De Ceulaer]

Errors, because negative times are shown as "#####"
Gilbert