Forum Discussion
cheezy
Aug 08, 2021Copper Contributor
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 works ok if columns [ Start Date and Time] and [Finished Date and Time] are on the same day.
But take for example the first duration in this image - the calculation ignores the fact that start and finish are on different days should be 28:26.
any ideas?