View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aj81a aj81a is offline
external usenet poster
 
Posts: 1
Default Average for times using minutes and seconds

Hi,

We need a formula to average out times in minutes and seconds (not AM/PM),
example B3 has 3.51, C3 has 3.42, D3 has 3.37 and E3 has 3.57 (formats for
these cells are just Number as using the Time format results in these times
being converted to AM/PM). Can anyone help, as using just an Average formula
results in results that are above 60 seconds.

Thanks, Adrian