Calculate Average Time Elapsed in Days, hours and minutes

macropod · #2 09-07-2015, 02:31 AM

Quote:

Originally Posted by Nina46

Im trying to calculate the average time elasped in 2 columns in Days, Hours and Minutes format. I have used

=INT(I10-H10)&" Days, "&HOUR(I10-H10)&" Hours, "&MINUTE(I10-H10)&" Minutes"

to get the time elapsed.

Why are you doing it that way instead of just using a custom number format? Since you're turning your calculation into text, there is no easy way to turn it back into a number for averaging. The only way around that would be to use a formula that goes back to the inputs, not the outputs.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trouble with absolute values and hours/minutes and formulas	dglazer	Excel	2	07-28-2015 01:42 AM
Need a formula to calculate turnaround time in hours	ram_cl1981	Excel	5	09-29-2014 02:20 PM
How to transform hours into minutes in mail merge	ppochelon	Mail Merge	1	09-29-2013 07:07 PM
Calculate difference by days and hours	alysolyman	Excel	6	05-13-2013 02:19 AM
Calculate elapsed time in Word table?	Snvlsfoal	Word Tables	1	08-11-2011 05:42 AM