Newbie Question - minutes and seconds

[mesa87]

Hello,

I've been trying to setup a spreadsheet where on of the columns is populated with lap times. Example, 2.30 would be 2 minutes and 30 seconds. How do totalize that column and get an average?

I tried converting the seconds to a decimal value, example 30 seconds would be .5 of a minute, but got nowhere...any help would be greatly appreciated.

Thanks,

Josh

[Leith Ross]

Hello Josh,

This examples adds five values using the format you described. The sum is broken down into hours and minutes.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[daddylonglegs]

If you're entering times in Excel then it's probably better to input in a format that excel will recognise, e.g. to enter 2 mins 30 secs

0:02:30

Then you can just use regulation SUM and AVERAGE formulas

...alternatively, if you really want to input times like 2.3, assuming you have time values in A1:A10 then use this formula in A12 for a sum

=SUMPRODUCT(INT(A1:A10)+MOD(A1:A10,1)*5/3)/1440

format A12 as [h]:mm:ss

then for an average

=A12/COUNT(A1:A10)

also format as [h]:mm:ss