Forum Discussion

cheezy's avatar
cheezy
Copper Contributor
Aug 08, 2021

sharepoint list difference in hours between two dates

i have a calculated column in a sharepoint list:   =IF(OR(ISBLANK([Finish Date and Time]),ISBLANK([Start Date and Time])),"",TEXT([Finish Date and Time]-[Start Date and Time],"hh:mm"))   This wor...
microsoft lists
Mutkuu's avatar
Mutkuu
Copper Contributor
Aug 08, 2021

cheezyit looks like your problem is with the TEXT function - it doesn't take days into account. If you had used the decimal format, you would have got the correct results.
Regards 🙂

Resources