Is this the type of result you’re expecting? Below are the screenshots provided for the reference -
I’m also attaching the PBIX file of the working for the reference. I’ve added the static time directly in the Power Query you can go through the simple transformative steps in it.
Just give a shout in case you need anything.
Hoping you find this useful and meets your requirements that you’re looking for.
Quick Note: I’ve separate the Submitted Date column into Date and Time columns so that I can use the DATEDIF function in the formula.
Thanks and Warm Regards,
store_time_query - Harsh.pbix (45.2 KB)