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
Avatar
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. 

    time*treat's avatar - radar

    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?

      Todd's avatar - Cylon 2.gif
      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!

        Avatar
        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. 

          time*treat's avatar - radar

          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.