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

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" <(E-Mail Removed)> wrote in message
news:61315D3A-45A6-4E24-A75F-(E-Mail Removed)...
> 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

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

sasa stankovic

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:61315D3A-45A6-4E24-A75F-(E-Mail Removed)...
>> 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
>
>