Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New user needing help with coming up with a formula
I am very new to excel and could use some help trying to do a formula. On my
worksheet Col B(Hrs Worked Today). Col C(Total hrs worked last 7 days). Col D(would be 70 hrs minus Col C). Col E(Total hrs worked last 8 days). I know the basic formulas to complete the above steps. B1 C D E 10 50 20 60 If I take a 34 hr rest period, I get a fresh 70 hrs which would put col c&e at 0 and col d at 70. I need a formula that will do this when I put an idenity (reset or 34 etc.) in B2 |
#2
|
|||
|
|||
I'm not sure how you're calculating column C now, but if I understand
you correctly: C2: =IF(B2="reset",0,<your existing formula) D2: =70-C2 In article , "Igniter" wrote: I am very new to excel and could use some help trying to do a formula. On my worksheet Col B(Hrs Worked Today). Col C(Total hrs worked last 7 days). Col D(would be 70 hrs minus Col C). Col E(Total hrs worked last 8 days). I know the basic formulas to complete the above steps. B1 C D E 10 50 20 60 If I take a 34 hr rest period, I get a fresh 70 hrs which would put col c&e at 0 and col d at 70. I need a formula that will do this when I put an idenity (reset or 34 etc.) in B2 |
#3
|
|||
|
|||
Thanks JE I will give this a try. On col C I would put =sum(B2:B6) manually.
Then the next cell I (b3) would put in =sum(B3:B7). Til i filled a full month period and just been copy and pasting a new month with the formulas. I knew theere probally is a easier way but I am new to excel. "JE McGimpsey" wrote: I'm not sure how you're calculating column C now, but if I understand you correctly: C2: =IF(B2="reset",0,<your existing formula) D2: =70-C2 In article , "Igniter" wrote: I am very new to excel and could use some help trying to do a formula. On my worksheet Col B(Hrs Worked Today). Col C(Total hrs worked last 7 days). Col D(would be 70 hrs minus Col C). Col E(Total hrs worked last 8 days). I know the basic formulas to complete the above steps. B1 C D E 10 50 20 60 If I take a 34 hr rest period, I get a fresh 70 hrs which would put col c&e at 0 and col d at 70. I need a formula that will do this when I put an idenity (reset or 34 etc.) in B2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
Excel user management | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
User defined charts- font size too small | Charts and Charting in Excel | |||
find and match the max | Excel Worksheet Functions |