alxine31245
New Member
- Joined
- Dec 9, 2018
- Messages
- 2
Hi, good day!
I'd like to seek some help regarding how to make different formulas for the Daily Time Record of an employee.
Situation: An employee logs in and logs out twice a day. Working schedule is 8:30 AM-12:00 PM then 1: PM to 5:30 PM with one hour lunch break.
Now, my teacher wants us to use different formulas especially an employee can log in before 8:30 or probably late. What formula can be used to calculate how many minutes an employee is late?
I'd like to seek some help regarding how to make different formulas for the Daily Time Record of an employee.
Situation: An employee logs in and logs out twice a day. Working schedule is 8:30 AM-12:00 PM then 1: PM to 5:30 PM with one hour lunch break.
Now, my teacher wants us to use different formulas especially an employee can log in before 8:30 or probably late. What formula can be used to calculate how many minutes an employee is late?