I'm having trouble getting a formula to work to calculate the total average time between times (start and end). Sheet: https://docs.google.com/spreadsheets/d/1X8EdejdzXMQg6x8k7ig5Jcdvdh2xQegu9lq4i6088ME
DateDif is the function that will do this individually (but only for days), I know using the
TEXT function with
DateDif could work (in my head). I've had issues getting it to work with
Average, segmenting by years:
I've also tried writing the following which hasn't worked, with me now confusing myself and head scratching as I've not managed to find a solution online:
The result I'm after is to have the total average duration for each year, reported in
I hope this makes sense and I've not confused you more than myself!