Singist Posted April 2, 2019 Posted April 2, 2019 Hello I have the following formula for a calculated column in a custom SharePoint Online list that calculates the total hours worked between 2 times and then deducting 30 minutes for lunch. =(IF([start Day & Time]="",0,([Finish Day & Time]-[start Day & Time]-"00:30")))*24 This formula works a treat and calculates the total hours worked. I now want it to deduct 30 mins from the total hours if those hours total more than 6. I have the tried this (which is the formula in my original spreadsheet), =(Finish time-Start time)*24-IF((Finish time-Start time)*24>=6, 0.5, 0) but I'm struggling to adapt it to work in SharePoint online. Any help would be greatly appreciated. Many thanks in advance
Recommended Posts