Excel Date and Time Formulas
October 9, 2018
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
To make data entry easier, you can create drop down lists in a worksheet, with Data Validation. Usually, things go smoothly, but sometimes the arrows for those drop down lists disappear.
On my website, I've got details on some of the reasons for missing arrows, such as incorrect settings, and even a linked picture.
Last week, I added another cause to that page -- macros that accidentally delete those arrows. If a macro deletes shapes on a worksheet, it might also delete the drop down arrow. Excel sees that as a shape!
To delete other worksheet shapes safely, without deleting the data validation arrows, see the macros to delete objects on Ron de Bruin's website.
If you're tired of doing repetitive tasks in Excel, learn how you can save time with macros. Jon Acampora is running free webinars on macros & VBA next week. Choose any date from Monday, October 15th to Friday, October 19th.
The free webinar is titled, "The 7 Steps to Getting Started with Macros & VBA". Jon will explain why you'd want to learn VBA and show how to get started writing your own macros.
Then if you want to dig deeper into Excel macros, Jon is running a new session of his popular VBA Pro Course. Sign up soon - registration is open for a short time only -- from Oct. 15 - 25, 2018.
Here are a few Excel articles that you might find useful or interesting.
Time Formulas - Doug Jenkins shows how to calculate the number of hours between two dates, and format the results in different ways. Read the update at the end, about the [h] format. (Level - All)
Automation - I love creating macros to save time in Excel, but are you automating yourself out of a job? What happens to all those free hours that you create at work? Thank to UniMord for the link. (Level - All)
There is a lovely new wall hanging in our front hall, thanks to my daughter, who started doing macramé this summer. Wikipedia says that macramé has been around since the 13th century, and I remember when it was popular in the 1970s. Back then, we used rough twine for our creations, not fancy coloured cord like this. And we even went to the Binder Twine Festival every year. Those were simpler times!
That's it for this week! If you have any comments or questions, send me an email.
NOTE: For the online version, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2018/20181009ctx.html
I'll also post any article updates or corrections there.
Last updated: October 5, 2018 2:23 PM