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!
- Myerith RaeAug 16, 2018Copper Contributor
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.