sharepoint list difference in hours between two dates

Copper Contributor

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. 

 

cheezy_0-1628422275002.png

any ideas? 

1 Reply

@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 :)