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 […]
Q: How can I open this [file type] file? When I click it it will not open. I often get calls from friends and colleagues to help them open a file that was either sent to them via email or something that is in their archives that they need to revisit. The answer is short […]
Q: Why the the leading zeros?
A: I’m Thinking ahead.
When working with numbers with text, adding leading zeros to a number keeps the alpha sort incorrect order.
This trick works on MS Word and most other programs. Have you ever tried to size a picture or logo to fit your document and get a distorted mess? There is a simple solution built into most programs, to resize the graphic, photo, logo, etc, click on the little bugger, hold your mouse pointer over […]