Number to Time

[G D]

I have one column of distances, and a given speed in another cell. I want have the time to travel these distances in an adjacent column. I am dividing the distance by the time and getting a number. I want to change this number into hours and minutes. When reformatting the cell to time it is changed to the 24hr clock, eg 0.271 is 06:30 when instead I want 0:16 (16 minutes).

Any help would be much appreciated.

Regards,

G

Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET MaskedTextBox Custom Control
http://www.eggheadcafe.com/tutorial...d645/aspnet-maskedtextbox-custom-control.aspx

 

[Jim Rech]

Divide your result by 24. Assign the cell a number/time format like
[h]:mm:ss.