Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula
I have done a excel work sheet to work out my wage but I am just stuck on one
thing. When I work longer than 8 hours I get an hours dinner brake unpaid. Im know wanting to know if there is a formula that works it out. In Cell B2 I have the time I started and in C2 the time I finish. In cell D2 I have the formula =SUM(C2)-(B2) that equals the total amount off hours I work. Well now I want it to automatically take 1 off if the hours are 8 or over 8. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |