Share
ReportHello,
Need some help with computing and totaling overtime using a list.
Have two columns, Log In and Log Off, that a third column (OT) currently calculates anything over 8 hours, using this formula for the column calculation:
=(IF(ISBLANK([Log In]),"",(IF(([Log Off]-[Log In])<=(1/24/60*480),0,TEXT(([Log Off]-[Log In])-(1/24/60*480),"h:mm")))))
I now need to have a total of this column (total overtime) visible on the list.
I understand I need a flow, but I just cannot seem to get the syntax correct.
The flow would be automated, set to trigger when the Log Off column is modified.
I am thinking that I can have the flow update the OT column with the amount of overtime, and then show a total on the main view. However I am struggling to convert the above formula to the correct syntax that the flow needs.
Any assistance would be much appreciated.
All responses (
Answers (
614
