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



"aj81a" wrote in message
...
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