| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
negative time summation calculation for a standard day
I am trying to use calculations with time in the form hh:mm - hh:mm and EXCEL
does not like negative time. The calculation is to accumulat over a week the actual time worked by aggregating the hours worked on a daily basis. Thus at the end of the week the time worked is ((monday time worked) XX:XX - 7:12 + (tuesday time worked) XX:XX - 7:12, etc for the week) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative Standard Deviations? | Excel Discussion (Misc queries) | |||
| Negative Standard Deviation? | Excel Worksheet Functions | |||
| Standard formatting not being applied to negative percents | Excel Discussion (Misc queries) | |||
| Summation of time | Excel Worksheet Functions | |||
| Standard deviation calculation | Excel Worksheet Functions | |||
Threaded Mode
