Hello,
Im working on a workbook that calculates total working hours on
monthly basis for each employee each employee should work 09:30 on
daily baisis
i am trying to find a formula that gives me the total of Over time
hours
During Weekdays: 1st 2 OVT hours will not be considered as an OVT but
if u stayed more than 2 hours on the same day u will add to ur
balance the 2 first hours as well.
During weekends and holidays : all attendance hours are considered as
OVT
my sheet is this way
A5=Date
C5=In
D5=Out
E5=Total hours
what i need is
Weekend OVT Hours F5
Weekdays OVT hours=g5

Waiting for your reply
Tia