Hi, I have 2 columns. Each column contains a date & time in "m/d/yyyy h:mm AM/PM" format.
I am trying to subtract the differences between two columns and am having a hard time. Any assistance appreciated and the desired result format is negotiable, so long as i get minutes difference....3 hours could be 180 minutes, etc. Thanks!
<tbody>
</tbody>
I am trying to subtract the differences between two columns and am having a hard time. Any assistance appreciated and the desired result format is negotiable, so long as i get minutes difference....3 hours could be 180 minutes, etc. Thanks!
TIME 1 | Time 2 | Desired Result |
3/4/2019 10:47 AM | 3/4/2019 10:45 AM | -2 Minutes |
3/5/2019 11:55 AM | 3/5/2019 12:55 PM | 60 minutes or 1 hour |
3/6/2019 11:45 PM | 3/7/2019 12:01 AM | 16 minutes |
<tbody>
</tbody>