Aug 08 2021 04:35 AM
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?
Aug 08 2021 05:46 AM
@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 :)