How To: Generate rows of date and limit the time difference

[askbyung1]

Hi,

I am looking for help to change the DateTime difference. Currently, I only can show the Start Date and End Date.  But, I'd like to make the End Date with more details as it is cut off by midnight each day.  Also, I want to make the time difference does not exceed 1440mins. Then it will need more rows of dates as shown in the screenshot below. Can you help me?  Thanks!!

Input

Start_Date	End_Date
5/5/2021 6:30	5/20/2021 8:00

Output

Date	Start_Date	End_Date	Diff
5/5/2021	5/5/2021 6:30	5/5/2021 23:59	1049
5/6/2021	5/6/2021 0:00	5/6/2021 23:59	1439
5/7/2021	5/7/2021 0:00	5/7/2021 23:59	1439
5/8/2021	5/8/2021 0:00	5/8/2021 23:59	1439
5/9/2021	5/9/2021 0:00	5/9/2021 23:59	1439
5/10/2021	5/10/2021 0:00	5/10/2021 23:59	1439
5/11/2021	5/11/2021 0:00	5/11/2021 23:59	1439
5/12/2021	5/12/2021 0:00	5/12/2021 23:59	1439
5/13/2021	5/13/2021 0:00	5/13/2021 23:59	1439
5/14/2021	5/14/2021 0:00	5/14/2021 23:59	1439
5/15/2021	5/15/2021 0:00	5/15/2021 23:59	1439
5/16/2021	5/16/2021 0:00	5/16/2021 23:59	1439
5/17/2021	5/17/2021 0:00	5/17/2021 23:59	1439
5/18/2021	5/18/2021 0:00	5/18/2021 23:59	1439
5/19/2021	5/19/2021 0:00	5/19/2021 23:59	1439
5/20/2021	5/20/2021 0:00	5/20/2021 8:00	480

[Emil_Kos · Accepted solution]

Hi @askbyung1,

I have made it work for you:

[Jonathan-Sherman · Accepted solution]

Hi @askbyung1,

I went for a slightly different approach to @Emil_Kos with most of the heavy lifting done in the formula tool:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Emil_Kos]

Hi @Jonathan-Sherman,

I need to start using the multi-field formula to parse more than one column at a time. Very elegant solution thank you for sharing!

[Jonathan-Sherman]

No problem at all!

[askbyung1]

Thank you so much for your help!