Page 2 of 15PREVNEXT

Make time count by using formulas

How time looks to Excel

Callout 1 What time looks like to you.
Callout 2 What time looks like to Excel.

When you type a time into a worksheet, Excel sees the information differently than you do. To you, 12:00 AM is the time of day expressed in hours and minutes. To Excel, 12:00 AM is decimal number 0, and 12:00 PM is decimal number 0.5. In this lesson you'll learn how Excel's view of times enables it to do time arithmetic, and how to type times in a format that Excel can understand. Learning a little about times before you do the math will save you time later on.

To continue reading this lesson on your own, click Next.

Page 2 of 15PREVNEXT