| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between 2 times
In article ,
"Niek Otten" wrote: Just subtract one from the other and format the result in some time format that doesn't give you the AM/PM But be cautious doing comparisons between the difference and another value (ie. was the difference less than or equal to 3 minutes 20 seconds?). You'll almost certainly have an answer of the form 19.99999975632 or 20.00000018463 seconds. -- David J Richardson -- http://davidj.richardson.name/ - Dr Who articles/interviews/reviews http://www.boomerang.org.au/ - Boomerang Association of Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference Between Two Times | Excel Discussion (Misc queries) | |||
| Difference between two times | Excel Discussion (Misc queries) | |||
| calculate difference between two times | Excel Worksheet Functions | |||
| Difference in Times | Excel Discussion (Misc queries) | |||
| difference between 2 times | Excel Programming | |||
Threaded Mode
