ContributionsMost RecentMost LikesSolutionsRe: How to calculate total time for which a field held a particular valueSounds complicated. Any other easy way?How to calculate total time for which a field held a particular valueWe have a ticketing system and to solve a ticket, we often need to gather additional information from the ticket opener and a TPA. For each ticket, we log all activities (in a child table) in form of activity types like email received from, email sent to, left voice message for, etc. Based on the latest activity type and date, we update a responsible party field (is a formula text field) in the parent/tickets table with the party who we are currently waiting on - Us, Ticket opener or the TPA. During the lifetime of a ticket, I want to calculate how much time each party spent on that ticket. Let me know if you need more information.