Skip to Content
0

How to put in all missing times in a single date?

Feb 01, 2017 at 10:17 PM

45

avatar image

Similar to

https://blogs.sap.com/2011/12/13/displaying-all-missing-dates-in-a-range-a-custom-function-sample/

I'm trying to figure out to fill in missing times ( in half hour intervals) for a single date.

The purpose is to find gaps in schedules.

So where I have

Start Time End Time Service Code

9:00 10:00 33

10:30 11:30 34

12:00 1:00 68

1:00 2:00 22

3:00 4:00 34

4:00 5:00 37

I want to also be able to see

Start Time End Time Service Code

9:00 10:00 33

10:00 11:30 Open

11:30 12:00 34

12:00 1:00 68

1:00 2:00 22

2:00 3:00 Open

3:00 4:00 34

4:00 5:00 37

How would I accomplish that?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers