Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)