View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Averaging durations formatted as hh:mm?

Hi Terry,

Am Sun, 05 Jan 2020 19:26:26 +0000 schrieb Terry Pinnell:

I have a column of durations formatted as hh:mm. Is there a formula I can enter
below which will display the average duration please? Or must I resort to VBA?


as for numbers you can use AVERAGE for times too.


Regards
Claus B.
--
Windows10
Office 2016