Solved

How to calculate duration based on Day Date Time Stamp

Posted on 2011-09-29
4
276 Views
Last Modified: 2012-05-12
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
Comment
Question by:BrianEsser
  • 3
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36816981
Hello Brian try this formula in B2 copied down

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

format as h:mm

regards, barry
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 36816993
See attached

barry
27362117.xls
0
 
LVL 50

Expert Comment

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

barr
0
 

Author Closing Comment

by:BrianEsser
ID: 36817207
Doesn't get any more elegant than that - Thanks!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question