decimals to minutes?

[William Stokes]

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

 

[Sandy Mann]

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 address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[William Stokes]

Thanks.

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

-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 address removed)
Replace @mailinator.com with @tiscali.co.uk

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

 

[Sandy Mann]

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 address removed)
Replace @mailinator.com with @tiscali.co.uk