| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
subtracting times using 24 hour clock
I want to calculate a period of time in 24 hours to be able to work out the
running speed of a machine. This is ok using say 18:00 to 21:00 the resulting time can be shown as a decimal & the machine output divided by the result, however how do I calculate the difference over the midnight period ie say 11:30 to 02:00? -- Andrew P. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting times | Excel Discussion (Misc queries) | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
| How do I sum times to get a total hour value? If I add up to 24 h. | Excel Discussion (Misc queries) | |||
| Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) | |||
| convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions | |||
Threaded Mode
