Chapter 12. Time and time functions
Questions answered in this chapter:
How can I enter times in Excel?
How can 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 can I extract the hour, minute, or second from a given time?
Given work starting and ending times, how can 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 6 that Microsoft Excel 2013 ...
Get Microsoft Excel 2013: 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.
