Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas in Excel
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 | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |