0
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.
Subscribe
Recent Posts
- Self Employed September 16, 2019
- #045 Trigger Warning January 4, 2019
- Music: Good for the Soul September 7, 2018
- #036 Ringie-Dingies: Erupting Telemarketer August 31, 2018
My Gravitar
Personal Links
Tags
#fakecalls
1099
algebra
blog
blogger
blogging
compatible files
computer problems
conditional formatting
Construction Billing
convert file
copy machine
coworkers
custom error checking
Data
data entry
detective work
email
employees
fake news
graphic
Julie's Dream House
logo
Math
Movie Moment
MS Excel
MS Word
order of operation
PEMDAS
photos
privacy
resize
security
Social Media
Sorting
Sorting text with numbers
taxes
telemarketers
The Ugly
translate file
truth
UGH
waiting your turn
xerox machine
year end