In my Social Media spreadsheet I want to add 30 minutes to the starting time for the post. Why 30 minutes? That’s the default scheduling time in Google Calendar.
To do this, I use the TIME function. The TIME function has 3 arguments; hour, minute and seconds – all three arguments are required. So my formula would look something like this:
=F2+TIME(0,30,0)
So, I’m adding 30 minutes to the value from cell F2. Easy!
This post is originally from 2016. If you want help with the newest and classic features in Excel drop me a line at catharine@mytechgenie.ca