When calculating times, Excel offers rounding functions to round results to the nearest day, hour, minute, or multiples of each, like the nearest 15 minutes.
- [Instructor] When you're calculating time differences…both within a day and across multiple days,…you sometimes will want to round the results.…We see some headings here on this worksheet…called rounding time.…Not only for a difference but rounding the result…to the nearest day or to the nearest hour…or maybe even to the nearest 15 minutes,…and you could probably imagine running these…to five minutes, 10 minutes, and so on.…Lots of different options here.…These are not difficult calculations…but you will sometimes run into problems…and oddities about how we display the results.…
So we've got two times here in cell A2 and AB.…How much time is elapsed?…A simple formula, equal the later time minus the earlier.…We get an answer.…And that is correct.…We could phrase this as almost 3.7 days,…but I think most of us would prefer to see this…in hours and minutes.…So we can immediately jump into format cells…either by right clicking this entry.…Choosing format cells,…or perhaps slightly faster, Control 1,…and we will want to go to the Time tab,…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.