Time Functions

 Time functions in Excel

Using time functions in Excel you can calculate, for example, how many hours or minutes an employee spent on a task or how many hours and minutes it took for the chemical reaction to complete. If you are diabetic and taking insulin injections, you can see how your sugar level is controlled over time.

  • Microsoft Excel recognizes information as time if hours, minute and seconds are separated by colons. Example: 8:30:05 AM
  • Times are stored in Excel as decimal numbers. Midnight 12:00 AM is 0 and noon 12:00 PM is stored as 0.5
  • You must enter a or p after the time or Excel assumes it is AM

The training video demostrates how to use formulas to calculate time in Excel.

Further reading:
Dates And Times In Excel
How to use dates and times in Excel

One thought on “Time Functions

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.