Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
timesheet with running total of overtime | Excel Worksheet Functions | |||
timesheet with running totals of overtime | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Timesheet functions | Excel Discussion (Misc queries) | |||
IF or SUMIF help for Overtime Formula | Excel Worksheet Functions |