#1
|
|||
|
|||
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 this formula to to get the time elapsed =INT(J33-D33)&" days "&TEXT(J33-D33,"h"" hrs ""m"" mins """) However, when I try to get the average in the column in cell L46 I get either #DIV/0 or #Value! error message. Here's the spreadsheet I'm working on Average Time in Days & Hours.xlsx - Google Drive Any help would be most appreciated Thanks |
#2
|
||||
|
||||
In L3 enter =J3-D3 then create a custom format like dd "days" hh "hrs" mm "mins"
Now you get "12 days 13 hrs 30 mins" BUT the underlying value is still a number Pull down as required Average as usual and apply the same custom format BTW please post your sheet on the board. External links are unsafe and not everyone can access them |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to calculate average time | aymanharake | Excel | 6 | 02-17-2017 04:22 PM |
Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
Calculate Average Time Elapsed in Days, hours and minutes | Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
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 |