Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Tunalover

Mechanical
Joined
Mar 28, 2002
Messages
1,179
Location
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top