want to learn
New Member
- Joined
- Aug 25, 2007
- Messages
- 33
Cant figure this out!
I have a column with a date (8/24/2007) and column with a start time in 24 hour format 16:50:37and a column with a stop time in 24 hour format 3:23:29. In the cells to the right I want the total number of hours:minutes:seconds from the time the event started till it stopped. As you can see the time crossed midnight.
Can someone help me with this formula?
I have a column with a date (8/24/2007) and column with a start time in 24 hour format 16:50:37and a column with a stop time in 24 hour format 3:23:29. In the cells to the right I want the total number of hours:minutes:seconds from the time the event started till it stopped. As you can see the time crossed midnight.
Can someone help me with this formula?