Trying to calculate hours between two dates on a SharePoint List

Question

Hi Guys,&nbsp;I am trying to calculate hours between created and modified date, I have tried&nbsp;=TEXT(Modified-Created,"h")&nbsp;but it doesn't work. I have read that it only really works if it is within 24 hours.&nbsp;J

matti paukkonen · Answer

Hi&nbsp;Jbrines1969,&nbsp;Here is a formula, which will calculate hour difference between two dates.=INT(Modified-Created)*24+HOUR(Modified-Created)&nbsp;

jbrines1969 · Answer

Matti Paukkonen&nbsp;&nbsp;Is it possible to get the hours between a modified date and Now or Today?

matti paukkonen · Answer

Jbrines1969&nbsp;&nbsp;That is not going to work, because calculated field values are only updated when list items is modified.

jbrines1969 · Answer

Matti Paukkonen&nbsp;&nbsp;So this calculation to get Days Old isn't really showing a true calculation?&nbsp;=IF(LEN([Date Assigned to Sub])=0,0,DATEDIF([Date Assigned to Sub],TODAY(),"d"))&nbsp;If it is then is there any way of changing it calculate hours.&nbsp;This was created when I created the SharePoint list by the system

Forum Discussion

Trying to calculate hours between two dates on a SharePoint List

Share

Resources