Hello,

If I calculate:

Speed: 90km/h
Distance: 1240 km

1240/90=13,77777

How do I convert this result 13,7777 to a "human readable" format like
13:47:00? (13 hours and 47 minutes)
(actually I dont need seconds, just full hous +minutes)

Thanks
-Will

With 1240 in A1 and 90 in B1 use:

=ROUND(A1/B1*60,0)/60/24

formatted as [h]:mm in case you ever got over 24 hours

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"William Stokes" <(E-Mail Removed)> wrote in message
news:e6%(E-Mail Removed)...
> Hello,
>
> If I calculate:
>
> Speed: 90km/h
> Distance: 1240 km
>
> 1240/90=13,77777
>
> How do I convert this result 13,7777 to a "human readable" format like
> 13:47:00? (13 hours and 47 minutes)
> (actually I dont need seconds, just full hous +minutes)
>
> Thanks
> -Will
>
>
>
>
>

Thanks.

You propably ment "*60;0"? At least this works for me...

-Will


"Sandy Mann" <(E-Mail Removed)> kirjoitti
viestissä:(E-Mail Removed)...
> With 1240 in A1 and 90 in B1 use:
>
> =ROUND(A1/B1*60,0)/60/24
>
> formatted as [h]:mm in case you ever got over 24 hours
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "William Stokes" <(E-Mail Removed)> wrote in message
> news:e6%(E-Mail Removed)...
>> Hello,
>>
>> If I calculate:
>>
>> Speed: 90km/h
>> Distance: 1240 km
>>
>> 1240/90=13,77777
>>
>> How do I convert this result 13,7777 to a "human readable" format like
>> 13:47:00? (13 hours and 47 minutes)
>> (actually I dont need seconds, just full hous +minutes)
>>
>> Thanks
>> -Will
>>
>>
>>
>>
>>
>
>

"William Stokes" <(E-Mail Removed)> wrote in message
news:eC$(E-Mail Removed)...
> You propably ment "*60;0"? At least this works for me...

Yes sorry I keep forgetting that not everyone uses the same system a me.
Glad that you got it to work.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk