I want to change the color of a time field based on it's running total value. I have a container set up with 5 different colors. I have a running total of time field set up to add the time it takes to get a days work done. I want the colors to change as the alloted time gets closer to the end of day. There seems to be a problem with the cal for anything over 4 hours. Is there something I need to know about adding time together?

Only that to calculate elapsed time for stuff like work done, the start date and end date need to be taken into account. Otherwise problems occur when somebody starts at 9:00 am and finish at 1:00 am.

Otherwise you'll have to post the calculation that giving problems.