| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time question
i need to find the difference in two times - displayed as a decimal - eg 1700
- 1830 = 1.5 so far my formula is: =IF(A2<"",TEXT(sheet1!K2)-(sheet1!J2)"h:mm","") where am i going wrong? cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Elapsed time question | Excel Discussion (Misc queries) | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| conditional formatting with time values | Excel Discussion (Misc queries) | |||
| Time Question...is this possible? | Excel Discussion (Misc queries) | |||
| rounding time question | Excel Worksheet Functions | |||
Threaded Mode
