From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use special formats for times over 24 hours

Use special formats for times over 24 hours

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Use special formats for times over 24 hours

“

- [Voiceover] We're looking at a worksheet called Autofill. Over in column L, we've got a column called Hours Worked. These numbers are not displayed the way we'd typically display times, although it's certainly ok. This represents six hours, 4 1/4 hours, of course, that's four hours and 15 minutes, 6 1/2 hours, 7 3/4, and so on. And we might wanna get a total for here. And we'll go to the bottom and simply press Alt + =. Gives us a quick total of the numbers. Enter. 280 hours. Now, we might wanna have these displayed as times. Be a better display, actually, because hours worked is typically displayed with a colon. Now, these are whole numbers. To convert them into dates, we need to divide this by 24. Equal this value divided by 24. And our answer here at first might be a little perplexing, .25. Well, 6 hours is a quarter of the day. Let's copy these down the column. What we next need to do is to apply a format. CTRL + 1 takes us to the Format Cells dialogue box pretty quickly. Go to…

Contents