| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting 24hr clocks?
HI, HELP!
I'm trying to generate the formula to subtract 24hr time clocks. If I want to work out the hours between 0500 and 1600 then it's a simple case of subtraction - however, the problem is when I try and reverse this. I'm trying to calculate a formula to work out the hours between, for example, 1600 and 0630 - the formula I've tried using doesn't work so is obviously wrong. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating 24hr Clock, but not as time!! | Excel Discussion (Misc queries) | |||
| Creating running clocks in multiple cells. | Excel Worksheet Functions | |||
| Converting format of hh:mm AM/PM to only hh:mm non 24hr in same co | Excel Discussion (Misc queries) | |||
| NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR . | New Users to Excel | |||
| 24hr moving average | Excel Discussion (Misc queries) | |||
Threaded Mode
