Custom colum formula help

[TORPIDO]

Hi

Im fairly new to power query and don't have any background on its formulas...

I have a time column "time" and want to have custom column "attendance" where it will see if "time" is above 07:30, it will return as Late.

Could you please provide the formula

Thanks

 

[ExceLoki]

here's a formula to help compare to the time and return late
------------------

Book1
	A	B
1	time	Attendance
2	7:30:00 AM	on time
3	7:22:00 AM	on time
4	6:45:00 AM	on time
5	7:42:00 AM	late
6	8:36:00 AM	late
7	7:32:00 AM	late
8	7:30:01 AM	late
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=IF(A2>=0.312511574074074,"late","on time")

 

[Kerryx]

in PQ try

if Time.ToText([Column1])> "07:30:00" then "LAte" else "on time"

 

[Kerryx]

column 1 being the column just containing time in hrs:min:sec e.g. 07:15:00