sorry in advance supernoob here failing hard and need help. I'm trying to create a timesheet in sharepoint that will eventually be a powerapp then go into PowerBI and I'm struggling bad with the sharepoint bit. So far I've got a column for the number of days between two dates( I've added +1 to count the current day). I've also got a column for users to select full or half days called H/F days.
What I want to do now is create a column called work hours - this should multiply the days by 7.4 if the H/F days column reads "full" and 3.7 if the HF days column reads "half".
In excel I would do it with sum IF and I could do it with PowerBI further on down the line, but I want the ux to be as streamlined as possible in PowerApps
So far I've tried =IF[h/fdays]=half,SUM[days]*3.7,IF[h/fdays]=full,SUM[days]*7.4
but I just get sharepoint fail screen , halp pls