+ Reply to Thread
Results 1 to 5 of 5

Convert Milliseconds into Hours Formula

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    14

    Convert Milliseconds into Hours Formula

    Hi y'all, my excel equation converts milliseconds to hours
    =(Z1(INT,"mm"),".",B5-(INT(C2/2000)*1000000))

    Does anyone have a better idea to do it? Thanks
    Last edited by Klmo; 03-21-2016 at 09:00 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,810

    Re: Convert Milliseconds into Hours Formula

    Try

    =(HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1))*1000

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Convert Milliseconds into Hours Formula

    Provided your data is stored as a time format in Excel it is treated as a fraction of a day. As there are 86,400,000 milliseconds per day (24 hours x 60 minutes x 60 seconds x 1000 milliseconds) you simply need to multiply the time by 86,400,000, eg =A1*86400000
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  4. #4
    Registered User
    Join Date
    08-25-2015
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    14

    Re: Convert Milliseconds into Hours Formula

    Thank you so much!
    Last edited by Klmo; 03-21-2016 at 08:35 PM.

  5. #5
    Registered User
    Join Date
    08-25-2015
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    14

    Re: Convert Milliseconds into Hours Formula

    You too Gak67!
    Last edited by Klmo; 03-21-2016 at 08:35 PM.

+ 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. [SOLVED] How to convert milliseconds to general number?
    By Sid_b23692 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-10-2015, 03:37 PM
  2. Convert time into hours formula
    By alfythom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-16-2015, 10:36 AM
  3. Formula to Convert [h]:mm:ss to d:hh:mm:ss ; where each 7.5 hours = 1 day
    By SenseiKibo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2015, 12:44 PM
  4. Formula to convert milliseconds into minutes
    By crashedinexcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-09-2015, 06:57 PM
  5. Convert milliseconds to minutes
    By bongielondy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2013, 06:57 AM
  6. Replies: 2
    Last Post: 03-16-2012, 06:51 AM
  7. Formula To Convert Hours(time) to Numbers
    By stefeb in forum Excel General
    Replies: 4
    Last Post: 05-02-2005, 02:58 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