time format problem
3 TopicsUsing 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.8KViews0likes2CommentsWindows 11 cannot display second in taskbar
I have consulted the information on this page and it has not been resolved. website:https://answers.microsoft.com/en-us/windows/forum/all/how-to-get-the-windows-10-clock-to-show-seconds/816c489c-2e93-45ce-ad56-9b9b9b93013f Restarting did not improve the problem.4.9KViews0likes1CommentTime format problem
I have a time format that excel can not understand because there is no space between the time and (am/pm) ie: (9:31AM) without a space. This prevents excel from running its normal equations on this format as the default format should be like this ( 9:31 AM). The format is an output of an app that I am supposed to export on excel and run my calculations, but because the app gives this format I can not deal with it. Do you have any solution or recommendations for this case ?994Views2likes0Comments