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 the Time category.…

We do not want to see AM/PM in these answers,…