I have a date time field to input working hours and then I need calculate total work hours. I was try using Global math expression in views, but the results is 0, although I was try to change views formmater from date and time, ago and plain.
This is the condition, lets say the rule in office is:
Employee In 1: 08.00 Employee Out 1: 12.00 Employee In 2 : 13.00 Employee Out 2 : 17.00
It's mean that employees must have 8 hours a day.
The question is, how can I calculate that employee is late in 2 hours if the field value like this:
filed Employee In 1: 09.00 <- late field Employee Out 1: 12.00 field Employee In 2 : 13.00 field Employee Out 2 : 16.00 <- earlier out
Is there any module date related or some one chould assist me ho to solve my problem?