Running total of time w/container

[scottvaughan]

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?

[Vaughan]

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.