|
|
#2
03-20-2021, 07:01 AM
|
||||
|
||||
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 
|
|
|
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 |
Windows 7 64bit 
Office 2010
Threaded Mode