From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Calculate time differences within days and across multiple days

Calculate time differences within days and across multiple days - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Calculate time differences within days and across multiple days

“

- [Instructor] In addition to containing all the tools 2 necessary for calculating differences 3 across different days, months, years, 4 Excel can also handle time differences, 5 perhaps within the day or across multiple days. 6 A simple example to begin with in column A, 7 time interval series. 8 Imagine we're talking about a transit system. 9 The first bus in the morning leaves at 5:30. 10 I can type five, colon, 30. 11 If I want to include the AM/PM with it, 12 I can type space, A, and enter, and there it is. 13 If there's a bus that leaves every 17 minutes, 14 at least for the next few hours, 15 I'll put it in the next entry, five, colon, 47, 16 every 17 minutes, space A. 17 Highlighting both of these, 18 it's a 17 minute interval, of course. 19 I'll drag from the lower, right-hand corner down to here. 20 Maybe after that, the interval's greater, 21 we'll deal with that later. 22 So that's easy to create. 23…

Contents