Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How can I convert or format an elapsed time to show mm:ss
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="FSt1, post: 3171930"] hi again. clicked the wrong button on the last post. sorry. excel keeps time as a percent of a day. 12 hours = .5 day 1 hour = 0.041666667 day or =1/24 1 minute = 0.000694444 day or =1/24/60 1 second = 0.00001157407407 day or =1/24/60/60 unless your 229.92 seconds are a decimal value of a day, you will have to do some math. multiply 229.92 by 0.00001157407407. format as time. about 3 minutes 50 seconds.(00:03:50) regards FSt1 [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How can I convert or format an elapsed time to show mm:ss
Top
