General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only