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.
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:
Retrieving data ...