| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formula
i have problems getting correct time.
A B C 1 16:00 00:30 2 15:43 23:49 3 13:55 00:01 In column C i want the time between A & B. But it keeps giving me 15:30 and it should be 8:30 Can anybody help. The formula i am using is (B1-A1) A is sign on time B is sign off time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula to do some calculations with time. | Excel Worksheet Functions | |||
| can excel calculate time increments in a formula? | Excel Worksheet Functions | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Threaded Mode
