Average for times using minutes and seconds

A

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
 
P

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
 
S

Sasa Stankovic

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

sasa stankovic

Peo Sjoblom said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top