when hours > "8:00" only show "8:00"

[okuser]

I have a formula that is adding time for the day. So if people go to clock out for lunch, it adds the 2 times together to give a total for the day. Is there a way to put a condition on that formula specifing that if the hours are greater than "8:00" only show "8:00" on the report?

Thanks

 

[bdreed35]

Here is a basic formula demonstrates what you could do.

IF Time_Field1 + Time_Field2 > 8 then
    8
ELSE
    Time_Field1 + Time_Field2

~Brian