Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to calculate late timings of employee i i tried but cant get correct values i attach my script file and excel sheet pls help.i wan to display Islate 1 if employee is late else 0 and in late timings i want to display how much late the employee is.
Hi, Try below script,
Attendance:
LOAD *, If(Num(Time)>Num(Time#('9:15:00 AM','hh:mm:ss[.fff] TT')),1) as isLate
;
LOAD EMP.CODE,
NAME,
DEPARTMENT,
DESIGNATION,
[D A T E] as Date,
[T ME IN],
Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) as Time,
ENT.TYPE
FROM
May 31, 2014.xls
(biff, embedded labels, header is 1 lines, table is [rptCUMTIMESHEETAll.rpt$]);
Use interval function man
Hi,
Please find the attachment. might help you ..
Thanks venkata for help , i want if time of employee time is greater than 9:15:00 AM then its show islate 1 and in time late difference in time.
Hi, Try below script,
Attendance:
LOAD *, If(Num(Time)>Num(Time#('9:15:00 AM','hh:mm:ss[.fff] TT')),1) as isLate
;
LOAD EMP.CODE,
NAME,
DEPARTMENT,
DESIGNATION,
[D A T E] as Date,
[T ME IN],
Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) as Time,
ENT.TYPE
FROM
May 31, 2014.xls
(biff, embedded labels, header is 1 lines, table is [rptCUMTIMESHEETAll.rpt$]);
thats work perfect
thanks alot