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
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.
Try
=(HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1))*1000
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.
Thank you so much!
Last edited by Klmo; 03-21-2016 at 08:35 PM.
You too Gak67!
Last edited by Klmo; 03-21-2016 at 08:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks