Power Query IF Time is

[Freeman2022]

Hello,

Is there a formula to use in Power Query for (If time is between 7PM and 7AM then After hours, if not then Business hours?

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ChangeType = Table.TransformColumnTypes(Source,{{"Time", type time}}),
    AddColumn = Table.AddColumn(ChangeType, "Category", each if [Time] > Time.From(19/24) or [Time] < Time.From(7/24) then "After Hours" else "Business Hours")
in
    AddColumn

Book2
	A	B	C	D	E
1	Time		Time	Category
2	5:08:56 AM		5:08:56 AM	After Hours
3	9:09:36 AM		9:09:36 AM	Business Hours
4	9:48:43 AM		9:48:43 AM	Business Hours
5	1:06:21 PM		1:06:21 PM	Business Hours
6	2:39:04 PM		2:39:04 PM	Business Hours
7	6:21:10 PM		6:21:10 PM	Business Hours
8	11:03:08 AM		11:03:08 AM	Business Hours
9	8:42:05 AM		8:42:05 AM	Business Hours
10	7:06:03 PM		7:06:03 PM	After Hours
11	8:33:16 PM		8:33:16 PM	After Hours
12	9:11:41 PM		9:11:41 PM	After Hours
13	11:14:45 AM		11:14:45 AM	Business Hours
14	8:21:48 PM		8:21:48 PM	After Hours
15	9:17:33 AM		9:17:33 AM	Business Hours
16	4:15:13 PM		4:15:13 PM	Business Hours
17	4:53:21 AM		4:53:21 AM	After Hours
18	12:06:39 AM		12:06:39 AM	After Hours
19	4:32:37 PM		4:32:37 PM	Business Hours
20	10:31:37 PM		10:31:37 PM	After Hours
21
Sheet3

 

[Freeman2022]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ChangeType = Table.TransformColumnTypes(Source,{{"Time", type time}}),
    AddColumn = Table.AddColumn(ChangeType, "Category", each if [Time] > Time.From(19/24) or [Time] < Time.From(7/24) then "After Hours" else "Business Hours")
in
    AddColumn

Book2
	A	B	C	D	E
1	Time		Time	Category
2	5:08:56 AM		5:08:56 AM	After Hours
3	9:09:36 AM		9:09:36 AM	Business Hours
4	9:48:43 AM		9:48:43 AM	Business Hours
5	1:06:21 PM		1:06:21 PM	Business Hours
6	2:39:04 PM		2:39:04 PM	Business Hours
7	6:21:10 PM		6:21:10 PM	Business Hours
8	11:03:08 AM		11:03:08 AM	Business Hours
9	8:42:05 AM		8:42:05 AM	Business Hours
10	7:06:03 PM		7:06:03 PM	After Hours
11	8:33:16 PM		8:33:16 PM	After Hours
12	9:11:41 PM		9:11:41 PM	After Hours
13	11:14:45 AM		11:14:45 AM	Business Hours
14	8:21:48 PM		8:21:48 PM	After Hours
15	9:17:33 AM		9:17:33 AM	Business Hours
16	4:15:13 PM		4:15:13 PM	Business Hours
17	4:53:21 AM		4:53:21 AM	After Hours
18	12:06:39 AM		12:06:39 AM	After Hours
19	4:32:37 PM		4:32:37 PM	Business Hours
20	10:31:37 PM		10:31:37 PM	After Hours
21
Sheet3

PERFECT!!!! It works...Thank YOU