Timesheet

2 Topics

Using calculated formulas for time in lists
I have [Check-In] and [Check-Out] time and date column entries I then have a [Total Time] calculated column which uses this formula =TEXT([Check-In]-[Check-Out],"h:mm") I can get the total time, however I need to be able to set an IF for if the [Lunch Break] column yes/no is "Yes" it will deduct -0.5 or 30mins in the [Total Time] I have attempted a few methods however I keep getting syntax or incorrect values.
Solved
Modula
May 04, 2022 Place SharePoint
7.7KViews
0likes
2Comments
Timesheet - Options
Hi all, I have all the Administrator rights to edit PWA settings and I wanted to check if there is an option in 'Timesheets' to apply the changes to the what checkboxes can be ticked/unticked across the tenancy as an admin? I tried looking for option in Server Settings but no success. For eg: I am trying to get rid of the 'Planned' task option across the users. How can I do it please? Thanks Jiti
JitiMinhas2810
Nov 10, 2021 Place SharePoint
601Views
0likes
0Comments