Forum Discussion
Excel time and date
Hi folks, I’m completely new around here and have actually been pointed this direction by Leila Gharani after asking a question on LinkedIn. So here goes, I am trying to create a master file in ...
NikolinoDE
Thank you very much for your reply and examples.
I have attached the file that you’ve made, I hope it explains what I am trying to do better?
The last bit I need to try and understand/make work is the Overtime Profile table. I would like it to calculate if an employee has claimed overtime based on the time/date columns. Any hours after 17:00-00:00 Monday to Friday are at x1.5 basic rate and 00:01-08:30 are at x2 basic rate.
I am trying to have this Overtime Profile table so that it makes payroll easier and takes the thinking out of totalling up hours.
Many thanks,
Paddy
Thank you very much for your reply and examples.
I have attached the file that you’ve made, I hope it explains what I am trying to do better?
The last bit I need to try and understand/make work is the Overtime Profile table. I would like it to calculate if an employee has claimed overtime based on the time/date columns. Any hours after 17:00-00:00 Monday to Friday are at x1.5 basic rate and 00:01-08:30 are at x2 basic rate.
I am trying to have this Overtime Profile table so that it makes payroll easier and takes the thinking out of totalling up hours.
Many thanks,
Paddy
Sorry that should read, “I have attached the file that I’ve made”