Hello @ray,
Thank You for posting your query onto the Forum.
As @marcster_uk suggested, you can try this by using the DATEDIFF function. Few days back similar type of query was posted by one of our member onto the forum. And below is the link provided for the reference about how the solution was achieved by using the DATEDIFF function.
I’m also providing the working of the Excel as well as the PBIX file for the reference.
Hoping you find this useful and meets your requirements that you’ve looking for.
Please Note: Just click on the link to view the entire post and not on the expand/collapse button.
Thanks and Warm Regards,
Harsh
Time Scheduled.xlsx (9.0 KB)
Time Scheduled.pbix (42.0 KB)