Spreadsheet Formula

Copper Contributor

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.

1 Reply

@Jenn1118 

 

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

 

NikolinoDE

I know I don't know anything (Socrates)