Working With Time in Excel

Posted by TetonTrekker on December 22, 2017 in Fly By Postings, Office Q&A, Tips for the common user |

When entering time in the cell don’t forget it starts with hours. Using a 24 hour clock is best, no need to type “am or pm”. Once you enter your time you can format the cell as needed and the formula will work. If you are only adding minutes and seconds, you still need the leading hours for the formulas and formats to work.

Tags: ,

Post a Memo

Copyright © 2013-2021 Julie: Girl Friday All rights reserved.
This site is using the Desk Mess Mirrored Child Child-Theme, v2.5.1511966596, on top of
the Parent-Theme Desk Mess Mirrored, v2.5, from BuyNowShop.com