Forum

Convert Excel formu...
 
Notifications
Clear all

Convert Excel formula to power query

3 Posts
2 Users
0 Reactions
203 Views
(@moshe_arama)
Posts: 14
Eminent Member
Topic starter
 

Hi !

how can i make function like excel in the power query
the excel function is :
=IF(AND(U3>=TIME(6,0,0), U3<=TIME(15,0,0)), "Morning", IF(AND(U3>=TIME(15,1,0), U3<=TIME(23,0,0)), "Evening",
"Night"))
U3 = COLUMN with time_for_shift_segmentation LIKE 10:59:00 I mean, based on the time, I want to know which shift it belongs.
 
 
CONVERT-TIME-TO-SHIFT-EXCEL.PNG
 
Posted : 25/04/2023 4:48 am
(@questvba)
Posts: 125
Estimable Member
 

Hi Moshe,

See in attachment.

BR,

Lionel

2023-04-24-12-19-38.png

 
Posted : 25/04/2023 6:20 am
(@moshe_arama)
Posts: 14
Eminent Member
Topic starter
 

Thank you Lionel  🙂

 
Posted : 26/04/2023 1:34 am
Share: