Hi Shokra,

Am Sun, 11 Nov 2012 01:54:16 +0000 schrieb Shokra:

There is one problem with the formula though :( That is, it is not
removing the overtime hours. There is no overtime, it becomes like hmm
"floating hours". So when I applied the formula to E17, it showed his
paid hours as 43, when technically if you minus the break & the
overtime, he only has 39.

what are the regular working hours for each day? Is working on weekend
completely overtime?


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2