Video: Add time

The best way to add time is to use the AutoSum button on the Home tab. You can also add a unit of time, such as 1½ hours, to a time of day, such as 10:00 a.m., by using the TIME function.

Other videos in this course

This video is part of a training course called Add or subtract time. You can download the entire course or watch the videos online:

  1. Video: Add time. (You are here!) The best way to add time is to use the AutoSum button on the Home tab. You can also add a unit of time, such as 1½ hours, to a time of day, such as 10:00 a.m., by using the TIME function.
  2. Video: Subtract time. You can subtract time in Excel almost like you subtract other types of numbers. To do this, you use a formula; there isn’t an AutoSubtract button. Like with adding time, you can also subtract a unit of time, such as 1½ hours, from a time of day, such as 10:00 a.m., by using the TIME function.

Need a reminder of what you learned? See the course summary.

Ready for another tutorial? See the complete list of Excel 2013 training courses.

Rating:
Applies to:
Views:
32980
Submitted on:
6/22/2013
Length:
00:03:33