| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate time difference in hrs
Dear All,
which functions shd i use to calculate the time difference between or with ref. to 2 dates i.e: 23/Nov 2300hrs - 25/Nov 0100hrs = 26hrs (result I want) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to calculate time difference in hrs
A1 = 23/Nov 2300hrs
B1 = 25/Nov 0100hrs C1 = Formula =(A1-B1)*24 "Will" wrote: Dear All, which functions shd i use to calculate the time difference between or with ref. to 2 dates i.e: 23/Nov 2300hrs - 25/Nov 0100hrs = 26hrs (result I want) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate time difference | Excel Discussion (Misc queries) | |||
| how to calculate time difference in hh:mm:ss | Excel Discussion (Misc queries) | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| calculate difference of time | Excel Programming | |||
| How do I calculate Time difference from PM to AM | Excel Discussion (Misc queries) | |||
Linear Mode
