Welcome Guest
Log In | Register )
You last visited December 3, 2016, 12:35 pm
All times shown are
Eastern Time (GMT-5:00)

# off topic, for excel people

Topic closed. 4 replies. Last post 11 years ago by time*treat.

 Page 1 of 1
PrintE-mailLink
Anna, TX
United States
Member #26720
November 21, 2005
263 Posts
Offline
 Posted: January 11, 2006, 4:16 pm - IP Logged

I need to have a formula that converts time. What I mean is, change it to decimals.

so for instance I put in 15:30 (hour, min)

I want the formula to divide the minutes by 60 and display the decimal version of that.

So it would give me 15.5

anyone know? I have been looking, but can't find the answer.

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: January 12, 2006, 5:54 am - IP Logged

Do you want to convert your system's time, or any arbitrary time you input?

Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
23259 Posts
Offline
 Posted: January 12, 2006, 6:13 am - IP Logged

I know that Visual Basic stores time and date information internally as a number, with the date being the part to the left of the decimal and the time to the right of the decimal.

VB has two functions -- DateSerial() and TimeSerial() -- which extract the numeric representations.

You may be able to use TimeSerial(), and then create some kind of multiplication formula or something that converts it into the hour.minutes format that you want.

Check the State Lottery Report Card
What grade did your lottery earn?

Sign the Petition for True Lottery Drawings
Help eliminate computerized drawings!

Anna, TX
United States
Member #26720
November 21, 2005
263 Posts
Offline
 Posted: January 12, 2006, 1:55 pm - IP Logged

any time I input. This is actually for work...haha.

i looked at the time serial, I may need to look at it harder.

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: January 12, 2006, 2:59 pm - IP Logged

Put your time in cell(1,1). e.g. 17:45

Make sure there is no date component by looking in the formula bar up top.

(it should read 5:45:00 PM with no date.)

In cell(1,2) type  =RC[-1]*24 set number format in cell(1,2) to general

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

 Page 1 of 1