SharePoint Online List Calculated Column

[Singist]

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