by Nate Moore | Jun 29, 2011 | Functions
It won’t take HOURs to explain HOUR, MINUTE, and SECOND in Excel Video 170. All three functions are very simple. The format is = HOUR(cell reference). MINUTE and SECOND work the same way. You’ll see how I use each of the three functions to pull the respective piece of...
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....
