V
vinu
Hi all,
I need a help and I'm sure will get it here...
I'm preparing an OnTime report and in that I want to differentiate the
delay in to 3 types
Below is the scenario..
Shift time is in Column A, Log in time in Column B, Status in Column C
If the Shift time -6.30pm
Login time -6.30 or less then 6.30 -in the status cell "0"
Login time -with in 15mins -in the status cell "1"
Login time -with in 16-20mins -in the status cell "2"
Login time -with in 21-30mins -in the status cell "3"
Login time -Beyond 30min -in the status cell "4"
Thanks in anticipations...
Vinu
I need a help and I'm sure will get it here...
I'm preparing an OnTime report and in that I want to differentiate the
delay in to 3 types
Below is the scenario..
Shift time is in Column A, Log in time in Column B, Status in Column C
If the Shift time -6.30pm
Login time -6.30 or less then 6.30 -in the status cell "0"
Login time -with in 15mins -in the status cell "1"
Login time -with in 16-20mins -in the status cell "2"
Login time -with in 21-30mins -in the status cell "3"
Login time -Beyond 30min -in the status cell "4"
Thanks in anticipations...
Vinu