I have to calculate the amount of hours that a request takes to move through our system. I have several Date/Time fields to use in my calculation (formatted as YYYY-MM-DD HH:MM:SS). These are the fields I am using:
Origination Date/Time
HR Approval Date/Time 1
HR Approval Date/Time 2
HR Approval Date/Time 3
HR Approval Date/Time 4
I need the difference between the last HR Approval we have received and the Origination Date/Time. I know it's the difference between the Approval and Origination fields, but I'm not sure how to take into account that it can be any of the 4 approval fields. I hope this makes sense!
Thanks,
Jennifer
