Use special formats for times over 24 hours

- [Instructor] On the autofill worksheet…in our chapter nine file,…off to the right, columns N, O, column R as well,…we've got some related information.…And the heading here in column O says hours worked,…and there's nothing wrong with this kind of an entry,…but if you are working with times,…it might be better to display these with a colon.…Now we can certainly work with these…and the 4.25, meaning four and a quarter hours…could be displayed as four colon 15,…four hours and 15 minutes.…That might be a better way to do it.…Now, I've copied the project numbers over here.…

These are the same ones we see in column N,…just for some of these.…Let's enter these as times, but not actually type them.…What you might not know is that hours worked…displayed this way has the value six.…If we display it as six colon zero zero,…we're actually entering the value 0.25.…Times are stored as values and a day, 24 hours,…has a value of one.…So if I type six colon zero zero here,…that's going to work okay,…but rather than doing that one by one for all these,…