Average for times using minutes and seconds

[aj81a]

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

 

[Peo Sjoblom]

They are not converted, just use hh:mm or [hh]:mm, all times default to the
type of time format the computer uses so you can bypass that by using the
above which is actually 24 hour format


--


Regards,


Peo Sjoblom

 

[Sasa Stankovic]

[hh]:mm should do the job but all data should be formated as time/date

sasa stankovic

They are not converted, just use hh:mm or [hh]:mm, all times default to
the type of time format the computer uses so you can bypass that by using
the above which is actually 24 hour format


--


Regards,


Peo Sjoblom

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