From the course: Excel Tips Weekly

Unlock this course with a free trial

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

How to create time interval entries

How to create time interval entries - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

How to create time interval entries

- [Instructor] In this worksheet, we see two sets of data, 2 first in columns A, B, and C 3 and over in columns H, I and J, essentially the same. 4 What we'd like to be able to do 5 and explore different options along the way 6 is to allow time entries here 7 to be entered in column C initially 8 and then have them adjusted to be to the nearest 10 minutes. 9 That's certainly one approach. 10 It does require additional space on a worksheet. 11 Another approach could be, off to the right, 12 for example, in column J, 13 what if we could force the user to make an entry 14 that's got to be an even multiple of 10 minutes, 15 in other words, a data validation rule 16 that will force the user to type in an entry 17 that must conform to that rule. 18 Different approaches here. 19 Let's first look at columns A, B, C, 20 and a formula that we're going to put in, in column D. 21 Now, we only want an adjusted time here 22 when there…

Contents