Time format problem
1 TopicUsing 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.Solved7.7KViews0likes2Comments
