I have two Tables, Service and TimeMGMT. From the Service Table I have a TimeMGMT portal. When the ticket Service::Status changes, a new Service::ModifiedTime is generated. The Service::TicketID and Service::ModifiedTime is copied to the TimeMGMT Table. The TimeMGMT Table's portal basically shows the life of a ticket from Open to Closed with timestamps to match each TimeMGMT Table record that was recorded for the specific Service::TicketID
I would like a clock/timer to start rolling/counting when a TicketID is in a Working status. If the TicketID goes into a Pending status I would like the clock to stop. If the TicketID goes back into a Working status then I would want the clock to start again. With this scenario I would then want to ADD the Times (however many) together to get a time in hh:mm:ss of actual work.