Set analysis calculating late timings of employee

[noman212]

Hello

i want to calculate the time difference i have excel sheet in which DATE field display time as 1/2/1900  9:06:00 AM, i just want to calculate late timing if time of emp exceed 9:15 then it count the time difference that how much emp late today.

pls help

thanks

[Gysbert_Wassenaar]

EmployeeArrivals:

Load *, if(IsLate, interval(Time - 925/2400,'hh:mm') as TimeLate ;

Load *, if(Time>925/2400,1,0) as IsLate ;

Load EmployeeID, DATE From myexcelfile.xlsx (oomxl, ...etc);

Expressions for use in charts:

sum(TimeLate)

count({<IsLate={1}>}EmployeeID)