| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate time difference in hh:mm:ss
I'm trying to find the durations between timecode in and out points. It seems
like it shoudl be easy using Excel formula, but I can't get it to work. Either the formatting is wrong, showing me a date, whcih I do not want, or I get an answer that goes over 60 in the seconds place. For example, I want to enter an in point of 02:42:15 (A1) with an out point of 02:43:20 (B1) and see a duration of 00:01:05 (C1). Can anyone help? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| Need formula to calculate time difference | New Users to Excel | |||
| Calculate time difference between cells | Excel Discussion (Misc queries) | |||
| How do I calculate Time difference from PM to AM | Excel Discussion (Misc queries) | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
Threaded Mode
