Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i need to class two hours !!
for example
range | operator | hour login | hour logout |
---|---|---|---|
09:00-10:00 | alex | 08:30 | 10:50 |
simon | 09:00 | 09:30 |
usually i used clas with only one value !!!
how can i do ?
I don't really understand what you are trying to do here.
thanks for reply, i try to explain better
my table have multiple timestamp login of operators
operator | login | logout |
---|---|---|
alex | 09:30 | 10:50 |
simon | 10:20 | 13:10 |
I need to count the minutes to login for each operator divided by hour (variable, can be 60 minutes, 30 minutes, etc)
operator | range | minutes logged |
---|---|---|
alex | 09:00 to 10:00 | 30 |
10:00 to 11:00 | 50 | |
simon | 10:00 to 11:00 | 40 |
11:00 to 12:00 | 60 | |
12:00 to 13:00 | 60 | |
13:00 to 14:00 | 10 |
usually for range a field i use "class", but my problem here i have two fields: login and logout..