Forum Discussion
Calculated Column with hours greater than 24 in SharePoint list
- Aug 16, 2018
I kinda go it to work, it still will not display in the [h]:mm:ss format if it is lager than a day, but at least it will be a number that could be used to figure things like employee's productivity for the week (i.e. if they worked [Column Name] number of accounts over [Calculated Column] time). There is possibly a better way to do this, but that is what I eventually worked out if anyone ever needs to do the same;
=(SUM((TIME((REPLACE([Column], 3, 6, "")), 0, 0)), (REPLACE([Column], 1, 2, "00")), (IF(((REPLACE([Column], 3, 6, "")) > 24), 1, 0)))
I think you have to look more into date then hours as hours are only 24.. use date diff to get to the correct result!
Not all entries will be over 24, all part time employees or anyone who doesn't work the full week doesn't have this issue.