+ Reply to Thread
Results 1 to 4 of 4

Converting hh:mm:dd to number of minutes in regular number format

  1. #1
    Registered User
    Join Date
    04-12-2010
    Location
    *
    MS-Off Ver
    Excel 2007
    Posts
    25

    Converting hh:mm:dd to number of minutes in regular number format

    Hello,

    How do you convert a certain amount of time into minutes in a regular number format?

    For example, I would like to convert "02:53:00" into "173".

    Thanks,
    David

    EDIT: title should read "hh:mm:ss"
    Last edited by blackmilk; 08-25-2012 at 04:56 PM. Reason: EDIT: title should read "hh:mm:ss"

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Converting hh:mm:dd to number of minutes in regular number format

    Custom format the time cell as [m] and you'll get total minutes......or with a formula in another cell try

    =A1*1440

    where A1 contains your time value - format as general
    Audere est facere

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

    Re: Converting hh:mm:dd to number of minutes in regular number format

    =A1*1440 and format as Number
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    04-12-2010
    Location
    *
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Converting hh:mm:dd to number of minutes in regular number format

    Awesome, that formula was exactly what I needed.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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