+ Reply to Thread
Results 1 to 3 of 3

Converting sum into hours and minutes (h:mm)

  1. 10-26-2013, 08:59 PM #1
    DSS90
    DSS90 is offline
    Registered User
    Join Date
    10-26-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    4

    Converting sum into hours and minutes (h:mm)

    I am a complete excel noob, and have no idea what I am doing but I have to complete an assignment for class and any help would be appreciated.
    For one of the questions, I have to convert a sum to show as hours and minutes (format h:mm). For example, the number I get is 163 and I need it to show as 2:43 (the total hours and minutes). How would I go about doing this??

    Thanks!
    Last edited by DSS90; 10-26-2013 at 10:02 PM.
    Reply With QuoteRegister To Reply
  2. 10-26-2013, 10:39 PM #2
    shepardrf
    shepardrf is offline
    Registered User
    Join Date
    10-16-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Converting sum into hours and minutes (h:mm)

    Lots of ways to do that. One is using Excel simple math formulas with one built in formula to find interger.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 10-26-2013, 10:44 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Converting sum into hours and minutes (h:mm)

    Hi and welcome to the forum

    This appears to be a homework ssignment, and forum rules prevent members from doing your homework for you, sorry

    However, we will be more than willing to guide and assist you with efforts you have already made Please show us what you have tried so far and what didnt work for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. converting minutes to days, hours and minutes.
    By TheGrimm in forum Excel General
    Replies: 8
    Last Post: 11-23-2015, 02:23 AM
  2. converting decimal numbers to hours & Minutes & Secs and multiplying hours by minutes & se
    By tigerpie in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-03-2013, 08:42 PM
  3. RE: Converting decimal minutes to hours, minutes and seconds
    By mills49 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-14-2013, 09:14 AM
  4. 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
  5. [SOLVED] converting Days Hours & minutes into just minutes in excel
    By Six Sigma Blackbelt in forum Excel General
    Replies: 5
    Last Post: 04-28-2006, 04:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1