NARAYANK991
Excel Ninja
Hi Lisa ,
It's late here , so I cannot be too detailed.
I have not yet put in the formulae to decide whether someone is late or early ; I wanted you to go through the report and verify that all the dates and times , both scheduled and earliest swipe-ins / latest swipe-outs are correct ; there is no point in putting in formulae to decide if the person is early or late if the swipe times and schedule times are not correct.
If you can try out these formulae which are already in place with different data sets and confirm that they work correctly , then putting in the last bit will not be so difficult.
Narayan
It's late here , so I cannot be too detailed.
I have not yet put in the formulae to decide whether someone is late or early ; I wanted you to go through the report and verify that all the dates and times , both scheduled and earliest swipe-ins / latest swipe-outs are correct ; there is no point in putting in formulae to decide if the person is early or late if the swipe times and schedule times are not correct.
If you can try out these formulae which are already in place with different data sets and confirm that they work correctly , then putting in the last bit will not be so difficult.
Narayan