Time Duration Formula
I have five (5) Date / Time type fields in my App. With a Handling Time Field (HT) - Formula Duration Type Example: T1: 07-27-2017 10:00 PM T2: 07-28-2017 08:00 AM T3: 07-28-2017 08:30 AM T4: 0...
Forum Discussion
Make a Formula Duration field:
If(IsNull([T3-time sent request]),
([T5-time completed]-[T2-time start process]),
([T5-time completed]- [T4-time received request])+([T3-time sent request]-[T2-time start process]))
Where your 'T" fields are all Date/Time types
If(IsNull([T3-time sent request]),
([T5-time completed]-[T2-time start process]),
([T5-time completed]- [T4-time received request])+([T3-time sent request]-[T2-time start process]))
Where your 'T" fields are all Date/Time types
This worked! Thanks!