AnsweredAssumed Answered

Adding Running-Time calculation

Question asked by xxx202xxx on Mar 13, 2017
Latest reply on Mar 14, 2017 by philmodjunk

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.

Outcomes