Sharepoint - Difference between two dates in hours The formula for calculating hours between two times is =TEXT([Column2]-[Column1],"h")