We are trying to create a Firm Calendar using Microsoft Lists w/ Calendar view. This works fine for just creating 'events' and using a webpart to display in our Hub site. The issue we are running into is that if an entry is made that has a start time of say '9:00am' and an end time of 10:00am, the Duration field comes up as 'this is a read-only field'.
If I change the start time to 9:01am and the end time as 10:00am, then the Duration displays as '59mins'
Trying to figure out why the duration doesn't just say '1 hr' if the meeting starts w/ X:00 am/pm time.
The code behind that field as it stands is:
"=CONCATENATE(IF(INT(([End Date and Time]-[Start date and time])*24)>0,CONCATENATE(INT(([End Date and Time]-[Start date and time])*24)," ",IF(INT(([End Date and Time]-[Start date and time])*24)>1,"hours","hour")),""),IF(MINUTE([End Date and Time]-[Start date and time])>0,CONCATENATE(" ",MINUTE([End Date and Time]-[Start date and time])," ",IF(MINUTE([End Date and Time]-[Start date and time])>1,"minutes","minute")),""))"
