I have a Start Date and Time column and a End Date and Time column, I also have a calculated column using a Single Line of Text formula:
=TEXT([End Date and Time]-[Start Date and Time],"d:hh:mm").
However this produces an error. It works with just
hh:mm as long as the two dates are the same date, but does not calculate past a 24hr time period.
So I would like to calculate and output the difference between any two dates in Days, Hours and Minutes. ie. 2 days 4 hours 30 minutes etc.
I don't have access to SharePoint Designer, and using enterprise SP2013.