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
|