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.