Excel 2010-Working with Dates & Times

About the Class:

This workshop lasts 90 minutes.

In this workshop, participants will encounter several situations that require calculations of elapsed time, whether it is in minutes, hours, days, or years. We will see how an employer might use Excel to: calculate hours worked by an employee in a given week; determine a date in the future, given a time frame in either work days or total days; determine the day of the week for a given date and highlight those that are weekends; and calculate the number of actual work days that are available between a certain date and a project’s deadline.

What You’ll Learn:

  • Enter time values into cells
  • Format cells to display time values correctly
  • Calculate lengths of time
  • Add together lengths of time
  • Use Conditional Formatting to highlight certain cell content
  • Explore Excel’s built-in time and date functions

What You Need to Know:

  • Enter text and numbers into a spreadsheet
  • Perform calculations with formulas and functions
  • Format cells and worksheets
  • Select ranges of cells
  • Apply Conditional Formatting – For help go to Online course materials

If you don’t have those skills, consider first taking the workshop:

  • Excel 2010 – The Basics

Resources

Excel 2010(PC) Excel 2011(Mac)
 Microsoft Office: Insert the Current Date and Time in a Cell Microsoft Office: Display Dates, Times, Currency, Fractions, or Percents
 Microsoft Office: TIMEVALUE Function Microsoft Office: TIMEVALUE Function
 Microsoft Office: TIME Function  Microsoft Office: TIME Function