I have read every single post I can find on calculated fields and some on dates, but I have yet to find a firm solution. Is the below scenario possible? If so, it is a gel script to populate the field, can calculated fields do it (so far I have no been successful in this)? Do I need multiple fields to represent it?
Scenario:
We have two dates. I want to be able to calculate the difference in those dates; however, the response could be days, hours, or only minutes of a combination. This must show in another field, so that it can be used in views/reports as well as on the screen.
Example:
System Down 9/18/2018 @ 10:00 AM
System Up 9/20/2018 @ 11:30 AM
Result : total downtime is 2 Days, 1 hr and 30 mins
OR
some records may be System down 9/18/2018 @ 10 AM system up at 9/18/2018 10:30 am. Total downtime is 30 mins
So there are variations.
Is this even feasible? Oddly, when I try a calculated field, it actually accepts/validates unit as all three (Day, Hour, Minute) but no matter what combination I used, it only populates the first unit value listed. Can the calculated expression be manually entered to make this work? Would a gel script/process do this (I am not skilled at that, but at least I would like to understand the feasibility of it)
Version 15.4.1
SQL
This is a custom subobject on the project object.
thanks!
Lynn