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
Adding minutes to hours/minutes 4
Excel - 24 time into absolute numbers or time *Tough One* 1
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 5
Locking a reference from one worksheet to another, in the same book(without moving when a row is add 1
Matching call data based on date, time and number called to give c 1
Need to separate multiple numbers in one cell 3
Want to count all repeated number only once in Excel 2007. 2

Top