# Convert Milliseconds into Hours Formula

1. ## 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

2. ## Re: Convert Milliseconds into Hours Formula

Try

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

3. ## 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

4. ## Re: Convert Milliseconds into Hours Formula

Thank you so much!

5. ## Re: Convert Milliseconds into Hours Formula

You too Gak67!

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

#### 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