Chapter 13. Time and Time Functions
Questions answered in this chapter:
How do I enter times in Excel?
How do I enter a time and date in the same cell?
How does Excel do computations with times?
How can I have my worksheet always display the current time?
How can I use the TIME function to create times?
How can I use the TIMEVALUE function to convert a text string to a time?
How do I extract the hour, minute, or second from a given time?
Given work starting and ending times, how do I determine the number of hours an employee worked?
I added up the total time an employee worked, and I never get more than 24 hours. What did I do wrong?
How can I easily create a sequence of regularly spaced time intervals?
Recall from Chapter 7, that Microsoft Excel 2010 ...
Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
