Forum Discussion
Trying to calculate hours between two dates on a SharePoint List
Hi Guys, I am trying to calculate hours between created and modified date, I have tried =TEXT(Modified-Created,"h") but it doesn't work. I have read that it only really works if it is wit...
Hi Jbrines1969,
Here is a formula, which will calculate hour difference between two dates.
=INT(Modified-Created)*24+HOUR(Modified-Created)