Number to Time

G

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
 
J

Jim Rech

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import only a specific column from another excel file 1
Excel time conversion - Please help!! 5
Excel drop list reference? 1
Removing various combinations of text and returning only a number inexcel 6
separate strings 2
i want to select a date in calander 1
Slow scroll with auto filter on 2
Excel formula help 9

Top