

New Member

December 17, 2022

I have a report that gives me date/time in one cell (example: 11/29/2022 4:49:03 AM) which I split the date and time. What I need is to take the time and breaking it down into one of six four-hour time slots...12:00, 4:00 & 8:00 am & pm.
A little background info…inventory refills print out every four hours, six times a day, 12:00, 4:00 & 8:00 both am & pm. The actual refill time is what is recorded in the report.
I need a simple formula I can run in my power query that will convert the "Actual Refill" time into the "Refill Run" time as shown on the attached file.
Btw, I'm using 2016.


Trusted Members
Moderators
Power BI

January 31, 2022

1 Guest(s)
