+ Reply to Thread
Results 1 to 6 of 6

Need to Convert Minutes to HH:MM please!

Hybrid View

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Need to Convert Minutes to HH:MM please!

    Good morning,

    I am in the midst of creating a new excel sheet for our employees to use. They will be entering numbers in B1 and B2 themselves and these numbers will stand for minutes (so ex 1808 is 1,808 minutes). I have the formula figured out and inputed for B3 which is obviously =sum(B1+B2). Now I need to figure out a formula for 3,437 minutes to show in terms in HH:MM in B4. Does anyone know how I can format this line to convert B4 to HH:MM? I appreciate your help! Thank you all! -Ali


    A B
    1 Time Logged (Medicaid Eligible) 1808
    2 Time Logged (Non Medicaid Eligible) 1629
    3 Total SC Time Logged 3437.00
    4 Total SC time (HH:MM) ????

  2. #2
    Registered User
    Join Date
    04-04-2013
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need to Convert Minutes to HH:MM please!

    Column A is supposed to be over the words and column B is supposed to be over the numbers sorry!!

  3. #3
    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
    53,048

    Re: Need to Convert Minutes to HH:MM please!

    Hi and welcome to the forum

    It would make things far simpler if you had them enter the actual times? Where is the 1808 etc comomh from?
    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

  4. #4
    Registered User
    Join Date
    04-04-2013
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need to Convert Minutes to HH:MM please!

    It's a report that auto prints out from a state website (that we have no control over). They calculate their time spent working by minutes served..... So total minutes is all that the employees are given. I was hoping to make it super easy for all of them to calculate to HH:MM for them :/ Is it possible? Thank you for your time!

  5. #5
    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
    53,048

    Re: Need to Convert Minutes to HH:MM please!

    duplicate post deleted
    Last edited by FDibbins; 04-04-2013 at 10:41 AM.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Need to Convert Minutes to HH:MM please!

    =(B1+B2)/1440 and format as [h]:mm
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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