How to calculate duration based on Day Date Time Stamp

I'm trying to come up with an elegant method to calculate the duration (in hours) of a process that executes at 4:15 AM every day.
The log produces a time stamp of when the process finishes
Trying to determine total duration for each run.
The attached Excel Workbook has the example data I'm working with.

Simplest solution wins the day and the points.

Brian DayDateEndTimeStampCalc.xls
Brian EsserZone Technology ExpertAsked:
Who is Participating?
barry houdiniConnect With a Mentor Commented:
Hello Brian try this formula in B2 copied down


format as h:mm

regards, barry
barry houdiniCommented:
See attached

barry houdiniCommented:
....or you might want to see the seconds - if so just change format to h:mm:ss

Brian EsserZone Technology ExpertAuthor Commented:
Doesn't get any more elegant than that - Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.