overtime on timesheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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.
 
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
 
Back
Top