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!

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...t.public.excel

you can download a workbook here

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


Regards,

Peo Sjoblom

"kimmyrt" wrote:

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
"kimmyrt" wrote in message
...
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!

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.

"IC" wrote:

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" wrote in message
...
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!

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

"kimmyrt" wrote:

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.

"IC" wrote:

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" wrote in message
...
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!