| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate saved or lost time
Have defined the cells customized as time h:mm
Let us say that a specified job should take "C19" = 1:20 (h:mm) Now it takes for someone "B19" = 1:18 (h:mm) Means minus 2 minutes better than standard. I write C20=C19-B19 get value not correct If time is higher than std time then value looks good. How should I write the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I lost a Spreadsheet : Can I search by the DATE I saved it? | Excel Discussion (Misc queries) | |||
| Lost my list box icon when saved as template. | Excel Worksheet Functions | |||
| lost work that wasn't saved. Can I retrieve it? How? | Excel Discussion (Misc queries) | |||
| adding a code to calculate how much time is lost | Excel Discussion (Misc queries) | |||
| recovering a lost book in excel that was not saved... | Excel Discussion (Misc queries) | |||
Threaded Mode
