Feb 18 2022 10:44 AM
Hello.
I have a spreadsheet where I calculate the total number of hours worked by employees. I want to be able to easily tell what hours are graveyard vs. regular. I am using the IF function, and am able to get one day of the week to tell me it's grave but I can't get it to work for multiple days in the week.
Feb 19 2022 02:38 AM
Here are some template examples from Microsoft
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file.
So you can get a solution that is tailored to your needs much faster.
*Knowing the Excel version and operating system would also be an advantage.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone :).
Hope I was able to help you with this info.
Thank you for your understanding and patience
I know I don't know anything (Socrates)