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.
Posted by TetonTrekker on December 22, 2017 in Fly By Postings, Office Q&A, Tips for the common user | ∞