+ Reply to Thread
Results 1 to 5 of 5

Hours and Minutes

  1. #1
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    146

    Hours and Minutes

    Hello,

    Please see attached... I am trying to add "h" and "m" (like Numbers for OS X does for their function "duration()") at the end of the totals column (row 27). For example instead of 78:00 it would be "78h 00m". The formatted cells are custom: "[hh]:mm"

    Thanks in advance!
    Nick
    Attached Images Attached Images

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Hours and Minutes

    Use the custom format of:

    [h]"h" mm"m"
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    146

    Re: Hours and Minutes

    I tried that before and it doesn't work.. the cell returns a value of "#########"...

    EDIT:
    disregard lol.. I feel stupid. It's because the cell was that much bigger than it wasn't long enough to show the extra characters. Wow, this has been bugging me for a few days.

    Thanks again!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Hours and Minutes

    Good deal. Thanks for the feedback!

  5. #5
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    146

    Re: Hours and Minutes

    done!

    ...........

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-21-2015, 01:56 PM
  2. convert days hours minutes seconds to just minutes
    By hollylynn in forum Excel General
    Replies: 4
    Last Post: 08-28-2015, 08:53 AM
  3. Excel 2007 : Convert number of minutes to hours and minutes
    By MikeFromIndy in forum Excel General
    Replies: 30
    Last Post: 06-05-2015, 08:10 AM
  4. Replies: 1
    Last Post: 08-08-2013, 09:21 AM
  5. Replies: 13
    Last Post: 05-03-2013, 08:42 PM
  6. Converting hours and minutes in military time to minutes
    By Argile79 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-13-2010, 02:42 PM
  7. add hours & minutes to other hours & minutes to receive total hou.
    By Wes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2005, 08:06 PM

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