We have two date columns (Start and End) and I need to be able to get the Total Days (in a formula).
i.e. Start 16 Aug, End 18 Aug = 3 days
Now the issue is the end might actually be at mid day on 18 Aug, so we would rather want the answer to be 2.5 days.
This decimal is important as we use it to track progress.
How can I get this?
We have explored the option of adding the “Add Time” option onto our date column and we thought we could subtract it somehow, but we never get this right.
Does anyone have any tips for how to solve this?