O'Reilly logo

Microsoft Excel 2013: 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 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 ...

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