+ Reply to Thread
Results 1 to 4 of 4

Time Conversions

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Seguin, TX
    MS-Off Ver
    Excel 20007
    Posts
    28

    Time Conversions

    Is there a simple way to convert a number representing minutes into hours and minutes?

    EX:
    A l B l C
    TOTAL MIN l Hours l Min
    135.37 l 2 l 15.6

    OR

    A l B
    TOTAL MIN l CONV
    135.37 l 2:15:36

  2. #2
    Forum Contributor
    Join Date
    06-07-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Time Conversions

    Try

    =A1/(24*60)


    Format as Custom

    [h]:mm

  3. #3
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Time Conversions

    Try in B1: =ROUND(A1/60,0) and in C1: =ROUND(A1-60*B1,0) That gives you hours then minutes and then if you wanted in D1 put =ROUND(60/(((A1)-(B1*60)-C1)*10),0) which gives you seconds

  4. #4
    Registered User
    Join Date
    06-06-2012
    Location
    Seguin, TX
    MS-Off Ver
    Excel 20007
    Posts
    28

    Re: Time Conversions

    Thanks guys. This gives me a few ways to format!
    @Thalassa & @amotto11

+ 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