Hi everyone,
How to split and expand the date and time with a formula or VBA?
I have the "start date and time" that begins in one date and sometimes ends in next day. For this cases I'd like to split in two
rows from begin date until same date up to 23:59 and continue in next row the next date until end hour. For the cases where start
date and end date is the same only split in one row.
Below is the input 2 columns with blue headers and output I'd like to get in green headers.
Thanks in advance.
How to split and expand the date and time with a formula or VBA?
I have the "start date and time" that begins in one date and sometimes ends in next day. For this cases I'd like to split in two
rows from begin date until same date up to 23:59 and continue in next row the next date until end hour. For the cases where start
date and end date is the same only split in one row.
Below is the input 2 columns with blue headers and output I'd like to get in green headers.
Start Date & Time | End Date & Time | Start Date | Start Time | End Date | End Time | |
10/13/2022 23:44 | 10/14/2022 2:20 | 2022-10-13 | 23:44 | 2022-10-13 | 0:59 | |
10/24/2022 23:17 | 10/24/2022 23:57 | 2022-10-14 | 0:00 | 2022-10-14 | 2:20 | |
2022-10-24 | 23:17 | 2022-10-24 | 23:51 | |||
Thanks in advance.