Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Cell format of Custom [h]:mm; working with question?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to take a cell formatted as Custom [h]:mm (which displays total time as 40:45 - hours and minutes) as 40.75 Hours (hours and percentage of hour for the remaining minutes)?

    Thanks in advance.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,656
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-01 05:10, JGExcel wrote:
    Is there a way to take a cell formatted as Custom [h]:mm (which displays total time as 40:45 - hours and minutes) as 40.75 Hours (hours and percentage of hour for the remaining minutes)?

    Thanks in advance.
    =A1*24

    where A1 houses a value like 40:45.

    Format the formula cell as General.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin, I am most thankful for your advise. It works like a charm as you know. I hope you too can get your questions answered so quickly and successfully.

    Best wishes!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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