Hi, I basically have Start time and End time. I need to add specific time slot 08-10, 10-12, 12-14, 14-16 Example: Input S.No. Start End * 08:01 10:00 * 08:31 10:30 * 09:01 11:00 * 10:31 12:30 * 11:01 13:00 * 12:01 14:00 * 12:31 14:30 Output S.No Start End Slot * 08:01 10:00 08-10 * 08:31 10:30 08-10 * 08:31 10:30 10-12 * 09:01 11:00 08-10 * 09:01 11:00 10-12 * 10:31 12:30 10-12 * 10:31 12:30 12-14 * 11:01 13:00 10-12 * 11:01 13:00 12-14 * 12:01 14:00 12-14 * 12:31 14:30 12-14 * 12:31 14:30 14-16 Note: I only want even slots, Hours starting from odd numbers will be lying in 2 different slots. Secondly, if minutes = 31 then also it will lie in 2 different slots. Please help, thanks in advance!

Addition of Rows on the basis of time slots

vidhuvaibhav

Hi,

I basically have Start time and End time.

I need to add specific time slot 08-10, 10-12, 12-14, 14-16

Example:

Input

S.No. Start End

08:01 10:00
08:31 10:30
09:01 11:00
10:31 12:30
11:01 13:00
12:01 14:00
12:31 14:30

Output

S.No Start End Slot

08:01 10:00 08-10
08:31 10:30 08-10
08:31 10:30 10-12
09:01 11:00 08-10
09:01 11:00 10-12
10:31 12:30 10-12
10:31 12:30 12-14
11:01 13:00 10-12
11:01 13:00 12-14
12:01 14:00 12-14
12:31 14:30 12-14
12:31 14:30 14-16

Note: I only want even slots, Hours starting from odd numbers will be lying in 2 different slots. Secondly, if minutes = 31 then also it will lie in 2 different slots.

Please help, thanks in advance!

Macros

Date Time

Accepted answers

danilang

Hi @vidhuvaibhav

Here's my take on it, using the Generate Rows tool to add rows where required

And the results

Dan

TimeSlots.yxmd

All comments

Thableaus

Hi @vidhuvaibhav

Here's what I thought.

Cheers,

SlotExample.yxmd

danilang

Hi @vidhuvaibhav

Here's my take on it, using the Generate Rows tool to add rows where required

And the results

Dan

TimeSlots.yxmd

vidhuvaibhav

@danilang,
Thanks for the solution. It really helped.!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703