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 gives ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.