I am looking for the correct formula to calculate the length of time between calls. This wil be calcluated using minutes and seconds. Example below.
68 (A1) * 00:00:35 = product (length of total time)
Thank you for your help
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Length of time
0
Answers
0
Just subtract the lower time from the higher time and make sure the cell's format is in h:mm:ss or mm:ss
If the time is in cell A1 and the second time in cell A2, it would look like this: =A2-A1
Updated
If you just want to display the time then you can simply multiply the 68 by the cell that contains the time. As long as it doesn't go over 24 hours, it shouldn't cause an issue for display purposes.
If you want to get the result in total seconds as an integer and not stored in Excel's time format, then you can do something like this:
=A1*(B1*86400)
A1 is the 68
B1 is the time
86400 is the number of seconds in a day.
This gives you the total time in seconds and you can do whatever you want with that number.
Make sure to format the cell with the formula as a Number or as General in order to see the result correctly.
Once you get the result in seconds, you can do whatever you like with that number to display the data however you want.
Discussion
Thank you for your response. The first is a numeric value like the number of calls taken and the second is the time.
senglish Aug 30, '17 at 8:27 am