
Roy Sitton
New Member
Members

Forum Posts: 2
Member Since:
December 17, 2022
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.

Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 486
Member Since:
January 31, 2022
January 31, 2022

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Vrinda Fernando
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
jo moffitt
Michael Zandt
Ibraam Nasif
Gali Balmocena
Jocelyn Degran
Nurul Amalina
Sarah Mooney
Gopinath Gopalan
Nick Pape
Fakhar Zaman
Forum Stats:
Groups: 3
Forums: 24
Topics: 6347
Posts: 27751
Member Stats:
Guest Posters: 49
Members: 32305
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
