View Single Post
 
Old 09-03-2015, 04:34 AM
Nina46 Nina46 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Sep 2015
Posts: 6
Nina46 is on a distinguished road
Question Calculate Average Time Elapsed in Days, hours and minutes

Hi!

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. However, when I try to get the average in the column I get either #DIV/0 or #Value! error message.

Some of the time elapsed goes over 30 days so just using I10-H10 doesnt give the correct answer in those instances.

Help!

Copy of some of the document below.

ORDERED DATEFILMED DATEREPORT DATEOrd-FilFil-Sig02/07/2015 23:1003/07/2015 10:1603/07/2015 12:040 Days, 11 Hours, 6 Minutes0 Days, 1 Hours, 48 Minutes03/07/2015 07:4403/07/2015 10:5403/07/2015 13:060 Days, 3 Hours, 10 Minutes0 Days, 2 Hours, 12 Minutes03/07/2015 11:4503/07/2015 12:1903/07/2015 13:100 Days, 0 Hours, 34 Minutes0 Days, 0 Hours, 51 Minutes02/07/2015 22:1302/07/2015 22:5403/07/2015 13:160 Days, 0 Hours, 41 Minutes0 Days, 14 Hours, 22 Minutes01/07/2015 22:1102/07/2015 03:1003/07/2015 14:080 Days, 4 Hours, 59 Minutes1 Days, 10 Hours, 58 Minutes

Thanks in advance!
Reply With Quote