AnsweredAssumed Answered

Need help with time calculation

Question asked by rubinjm on Feb 12, 2018
Latest reply on Feb 13, 2018 by philmodjunk

I need to take a timestamp field and add the number of minutes contained in 3 other fields to come up with a new timestamp.


Arrv Date_Time is a timestamp that contains date and time.

The 3 other fields are currently number fields that each contain the number of minutes between 2 different events.


I need to add those 3 elapsed times to the original timestamp to get a new timestamp.


I tried this calculation but it doesn't work. I'm assuming I need to do something different with the 2 number fields?


Final timestamp =

Arrv Date_Time + GetAsTime (Door to Triage) + GetAsTime (Triage Complete to Room) + GetAsTime (Room to Decision)