I have a SharePoint Calculated column that is supposed to calculate the difference in hours and minutes between two dates.
This is the expression I am using for that:
=TEXT([IN/OUT Time]-[Staging Time],"hh:mm:ss")
The only thing is, if the time is over 24 hours it shows up as if it is in days.
Example: if the difference is 24 hours and 7 minutes, the result of the above expression shows "00:07:00".
I want it to show: "24:01:00".