Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

How to calculate a time duration in hours and minutes given initial and final times 2

Status
Not open for further replies.

Tunalover

Mechanical
Mar 28, 2002
1,179
0
0
US
Folks:
I have a need to calculate an event durations in XX.XX hours given a start time YY:YY gm and end time ZZ.ZZ gm.

For example, YY:YY gm could be 7:13 am and ZZ.ZZ gm could be 3:23 pm. Can anyone clue me in on how to do this in Excel?

TIA
Bruce

ElectroMechanical Product Development
(Electronics Packaging)
UMD 1984
UCF 1993
 
Replies continue below

Recommended for you

Status
Not open for further replies.
Back
Top