Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kimmyrt
 
Posts: n/a
Default overtime on timesheet

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!

  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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!

  #3   Report Post  
IC
 
Posts: n/a
Default

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!



  #4   Report Post  
kimmyrt
 
Posts: n/a
Default

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!




  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
timesheet with running total of overtime kimmyrt Excel Worksheet Functions 2 January 26th 05 07:15 PM
timesheet with running totals of overtime Gord Dibben Excel Worksheet Functions 0 January 25th 05 01:45 AM
need help w/formula for calculating overtime hours jv749297 Excel Worksheet Functions 1 January 17th 05 08:54 PM
Timesheet functions Luc Excel Discussion (Misc queries) 5 January 5th 05 01:17 PM
IF or SUMIF help for Overtime Formula Myrna Excel Worksheet Functions 2 November 8th 04 05:01 PM


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"