Hi out there

My freind is running in freetime and use a computer (GPS)
to track speed, distance and so on

Now the problem is
when i put this data in excel it's output is difrent ! why ?

eks.(GPS)
Distance 17,820 (17 km 820 m)
Time 01:29:05 (1 hower 29 min and 5 second)
Result= 00:04:49 min/km

eks.(Excel)
A1=17,820
A2=01:29:05
A3=A2/A1 Result= 00:05:00 ! why not 00:04:59 ?

What result is right Excel's or GPS ?

thanks in advance

Excel looks right. 1:29:05 is 89.08333 minutes. Divide that by 17.82 and
you get 4.999065 minutes/km
--
David Biddulph

"excelent" wrote in message
...
Hi out there

My freind is running in freetime and use a computer (GPS)
to track speed, distance and so on

Now the problem is
when i put this data in excel it's output is difrent ! why ?

eks.(GPS)
Distance 17,820 (17 km 820 m)
Time 01:29:05 (1 hower 29 min and 5 second)
Result= 00:04:49 min/km

eks.(Excel)
A1=17,820
A2=01:29:05
A3=A2/A1 Result= 00:05:00 ! why not 00:04:59 ?

What result is right Excel's or GPS ?

thanks in advance

Hi David, thanks for reply

do u no af a excel formula to translate 01:29:05 to 89.08333

i tryed to use format in difrent way - no luck




"David Biddulph" skrev:

Excel looks right. 1:29:05 is 89.08333 minutes. Divide that by 17.82 and
you get 4.999065 minutes/km
--
David Biddulph

"excelent" wrote in message
...
Hi out there

My freind is running in freetime and use a computer (GPS)
to track speed, distance and so on

Now the problem is
when i put this data in excel it's output is difrent ! why ?

eks.(GPS)
Distance 17,820 (17 km 820 m)
Time 01:29:05 (1 hower 29 min and 5 second)
Result= 00:04:49 min/km

eks.(Excel)
A1=17,820
A2=01:29:05
A3=A2/A1 Result= 00:05:00 ! why not 00:04:59 ?

What result is right Excel's or GPS ?

thanks in advance

=A1*24*60
(Excel times are in multiples of a day, so *24*60 converts to hours then
minutes)
--
David Biddulph

"excelent" wrote in message
...
Hi David, thanks for reply

do u no af a excel formula to translate 01:29:05 to 89.08333

i tryed to use format in difrent way - no luck

"David Biddulph" skrev:

Excel looks right. 1:29:05 is 89.08333 minutes. Divide that by 17.82
and
you get 4.999065 minutes/km
--
David Biddulph

"excelent" wrote in message
...
Hi out there

My freind is running in freetime and use a computer (GPS)
to track speed, distance and so on

Now the problem is
when i put this data in excel it's output is difrent ! why ?

eks.(GPS)
Distance 17,820 (17 km 820 m)
Time 01:29:05 (1 hower 29 min and 5 second)
Result= 00:04:49 min/km

eks.(Excel)
A1=17,820
A2=01:29:05
A3=A2/A1 Result= 00:05:00 ! why not 00:04:59 ?

What result is right Excel's or GPS ?

thanks in advance