Skip to Main Content
Microsoft® Excel® 2010: Data Analysis and Business Modeling
book

Microsoft® Excel® 2010: Data Analysis and Business Modeling

by Wayne L. Winston
January 2011
Beginner to intermediate content levelBeginner to intermediate
720 pages
23h 29m
English
Microsoft Press
Content preview from Microsoft® Excel® 2010: Data Analysis and Business Modeling

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Wayne L. Winston
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780735656864Purchase book