Yes, I saw it.
I think you need to
1. Convert character times to real datetime values.
2. Compare times with the ranges table.
That's the idea.
>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?
If it's not broken, fix it until it is.
My Blog