Closed Thread
Results 1 to 3 of 3

How can I change time format to decimal without losing hours?

  1. #1
    Bushman
    Guest

    How can I change time format to decimal without losing hours?

    I am trying to enter a time of 33:13:00 and get a display of a decimal of
    33.21. If I format the box to be decimal when I enter the time it does not
    give the full 33 hours but in turn replaces it with 1.38. Is there are
    function or formula that will allow the user to type in the time in hours and
    minutes to convert it to a decimal format?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699
    If you input time in A1 then in B1

    =A1*24

    format as number

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    If a1 = 33:13:00 then in B1 enter =A1*24.

    VBA Noob

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1