by Nate Moore | Jun 27, 2011 | Functions
The time formatting we reviewed in the last Excel Video has a catch we’ll discuss in Excel Video 169. As long as there are less than 24 hours (or 60 minutes or 60 seconds), the formatting we introduced in the last Excel Video works just fine. As soon as you go over 24...
by Nate Moore | Jun 22, 2011 | Functions
Make the most of your TIME by watching Excel Video 168. I’ll cover three time related functions in this video. First, the TIME function lets you enter and/or calculate time in Excel, very similar to what we did with the DATE function in the last two Excel Videos. The...
by Nate Moore | Jun 20, 2011 | Functions
When we last left our heroes in Excel Video 166, we had a clever formula that automatically updated after entering data in one cell. In Excel Video 167, we’ll go one step further and automatically calculate that cell as well. When you open the spreadsheet now, all of...
by Nate Moore | Jun 15, 2011 | Functions
Excel Video 166 reviews four very basic Excel date functions, but we can combine the functions to make rolling reports update automatically. DATE is a function that lets you enter the year, month, and day separated by commas. Excel turns that information into a date....
by Nate Moore | Jun 13, 2011 | Functions
Excel Video 165 uses the WEEKDAY function to calculate which days are weekends to help you figure out call. The only trick to the WEEKDAY function is deciding which day of the week you want to call day 1. I typically use option 2 so that Saturdays are given the value...