Friends, in this video i have explained a formula with the help of which you can calculate the Penalty Amount if Office Employee Reach office late time after office timing. So here i have used MAX FORMULA, IF-ELSE FORMULA AND TIME FORMULA to solve the issue. I hope it will be very helpful for you. kindly watch the video starting to last.
=IF( ),=TIME(hr,mm,sec), =MAX( )
Watch This Video to Learn