hi Sergey,

>I do not understand the logic for hours assignment.
>There're 13 not 5 hours between "0600" and "1900".

the worker works between 14H and 23H.

all hours between 06H00 and 18H59 must be paied to 100 %
all hours between 19H00 and 20H00 must be paied to 120 %
all hours between 20H00 and 22H00 must be paied to 135 %
all hours between 22H00 and 06H00 must be paied to 150 %

5 because the begining is 14H00 and + 5 = 19H = 5 hours to 100%
1 because the begining is 19H00 and + 1 = 20H = 1 hours to 120%

is more comprehensible ?

>Also what is the meaning of 'user works betw "0600" and "1900"' ?









>
>
>>
>>i have a table with this structure
>>
>>cname C(8)
>>cbeginning c(4)
>>cend C(4)
>>nhours100 n(5,2)
>>nhours120 n(5,2)
>>nhours135 n(5,2)
>>nhours150 n(5,2)
>>eg
>>cname = "Isnight"
>>cbeginning ="1400" for beginning of team work
>>cend C(4) = "2300" for end of team work
>>
>>if user works betw "0600" and "1900" here i want nhours100 = 5
>>if user works betw "1900" and "2000" here i want nhours120 = 1
>>if user works betw "2000" and "2200" here i want nhours135 = 2
>>if user works betw "2200" and "0600" here i want nhours150 = 1
>>
>>which formula can i use ?
>>
>>thank in advance
>>
>>bernhart