I have been using Excel for quite a while but still do not know much about it.
I am busy trying to make our employee timesheets/payslips more user friendly.
Some employees in our company are paid according to the exact time they have worked e.g from 07:30 to 16:15 minus 30 minutes lunch. How would I set up a formula for this i.e.:
Time ended - time started - 30 minutes lunch = hours:minutes worked
Bookmarks