General information
Category:
Coding, syntax & commands
hi naomi,
please naomi see message to sergey...
>>hi all,
>>
>>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
>
>How did you get 5 and 1 for 1st and last record?
Previous
Next
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