Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Make time count by using formulas 
 
  Overview  
 Show/Hide lesson sections How Excel watches the clock
 Show/Hide lesson sections Use times in formulas
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
Calculate times by using formulas in Excel  

Learn how to calculate times by using formulas in Microsoft® Excel.

  • Length: 20–30 minutes
  

Next

GOALS

After completing this course you will be able to use formulas to:

  • Find the number of hours worked in a day or a week.
  • Convert a number from one unit of measure to another, such as years to minutes.
 
ABOUT THIS COURSE

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
COURSE TEXT

How many hours did you work this week? What's the total if you deduct your lunchtimes? In this course you'll learn how to use formulas to fill out a timecard in Excel. And just for fun, you'll find out how many minutes you've been alive, by using Excel to convert time from years to minutes.

To learn more about this course, you can read the overview in the center of this page or the detailed table of contents in the left column.

Click the Next button to start the first lesson.

 
BEFORE YOU BEGIN

You should complete the course Audio course: Get to know Excel: Enter formulas, or you should already be familiar with Excel formulas, functions, cell references, and function arguments.

  Go to previous page (disabled)    Next Go to next page
advertisement