sharepoint list difference in hours between two dates

Occasional Visitor

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? 

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