• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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.

Thanks!
Brian DayDateEndTimeStampCalc.xls
0
BrianEsser
Asked:
BrianEsser
  • 3
1 Solution
 
barry houdiniCommented:
Hello Brian try this formula in B2 copied down

=MID(A2,12,8)-"4:15"

format as h:mm

regards, barry
0
 
barry houdiniCommented:
See attached

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

barr
0
 
BrianEsserAuthor Commented:
Doesn't get any more elegant than that - Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now