Convert Time to numbers, seconds, hours and minutes in Microsoft Excel 2007

in MES Science6 months ago (edited)

In this video I show how the Microsoft Excel time format can be converted into a fraction of a day and from there you can display the day as hours, minutes or seconds. I used Office 2007 in this video but the same principle works for many different programs, even non-Microsoft spreadsheet type programs.

Download video notes:!As32ynv0LoaIic1OTPMhh5seZ4naQQ?e=vkZjW3

Watch video on:

View Video Notes Below!

Download these notes: Link is in video description.
View these notes as an article:
Subscribe via email:
Donate! :)
Buy MES merchandise!
More links:
Follow my research in real-time on my MES Links Telegram:
Subscribe to MES Truth:

Reuse of my videos:

  • Feel free to make use of / re-upload / monetize my videos as long as you provide a link to the original video.

Fight back against censorship:

  • Bookmark sites/channels/accounts and check periodically
  • Remember to always archive website pages in case they get deleted/changed.

Recommended Books:

Join my forums!

Follow along my epic video series:

NOTE #1: If you don't have time to watch this whole video:

Browser extension recommendations:

Microsoft Excel: Converting Time format to a number

Excel time to seconds Resized AI.jpg

“hh:mm:ss” to hours, minutes, seconds








The rewards earned on this comment will go directly to the people sharing the post on Reddit as long as they are registered with @poshtoken. Sign up at

Thanks for your contribution to the STEMsocial community. Feel free to join us on discord to get to know the rest of us!

Please consider delegating to the @stemsocial account (85% of the curation rewards are returned).

You may also include @stemsocial as a beneficiary of the rewards of this post to get a stronger support.