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".

Any thoughts?

1 Answer 1


Well, you are formatting the result to show only the time value, so what do you expect?

In Excel, you can use the [] brackets to show values greater than 24 hours in the hour part. Not sure it works in SharePoint, but you can try.


  • Thank you. I am new to this, so I appreciate you pointing that out, even though it was obvious to you.
    – TFalconer
    Jan 27, 2020 at 0:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.