Results 1 to 3 of 3

Thread: Time to Decimal

  1. #1
    Join Date
    Feb 2007
    Location
    Devon, UK
    Posts
    37

    Unanswered: Time to Decimal

    basically on my spreadsheet i have a list of times in the following format

    9.08 meaning Nine hours and Eight Minutes.


    Next to it have a column with the decimal equivalent


    Hours Decimal

    9.08 9.13

    this is currently calculated manually by just doing the simple calculation 8/60 = 0.13333333 and replacing the figure after the decimal with the new one, what i was hoping for was a way to calculate it automatically so that the decimal figure is produced without wasting time calculating the function manually and repeating.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. You could name the number and use that in a formula, so that it could be automatic. Or write VBA code that could do the same thing. You would need some kind of trigger event.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Feb 2007
    Location
    Devon, UK
    Posts
    37
    i have come up with a basic solution in a roundabout way, im sure it wasnt ideal but it works and its just a simple thing, i only did it as iim leaving my job soon and was making it easier every way i can on the new person taking over.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •