I am calculating the duration of a trip:
- Column 1 is a Date Column titled “Trip Start”
- Column 2 is a Date Column titled “Trip End”
- Column 3 is a Formula Field titled “Duration” where the Formula is Trip Start-Trip End
The formula result correctly outputs the duration in number of days, but the word “ago” is appended to the result, for example “3 days ago” even though the difference in dates is not “3 days ago” but “3 days”
Question: How do I either remove the word ‘ago’ from my result, or calculate the duration differently so that I see “X days” instead of “X days ago”?