Select Page

Excel Video 170 HOUR, MINUTE, and SECOND

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...

Excel Video 169 Time to Format Times

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...

Excel Video 168 TIME

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...

Excel Video 166 DATE, YEAR, MONTH, and DAY

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....