Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time sheet manipulation
Can some plaese tell me how I can get a negative time to show?
What I mean is this coloumn A as total worked time and coloumn B as weeks hours, so what i want is the sitiation where if coloumn A is smaller than B I get a negative time so that the rolling toil time is maintained ie week 1 I generate 8 hours toil week 2 I generate -2 hours toil so toatl is 6. The cells are formatted as time in the fashion of 37:30:55. MTIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet determination of what day and time rate | Excel Worksheet Functions | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Entering a number on any sheet one time only | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Excel formula for a time sheet | Excel Worksheet Functions |