View Single Post
 
Old 09-07-2015, 02:31 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Nina46 View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote