O'Reilly logo

Microsoft® Excel® 2010: Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required