Forum Discussion

Copper Contributor

Jan 07, 2023

Solved

How to associate a word with 0 hours

I am trying to make a work schedule. I am not good with Excel. I am using an excel sheet that allows me to calculate the total hours worked for each person for that week. The only issue I am having i...

excel

Excel on Mac

Formulas and Functions

Rodrigo_
Jan 07, 2023
Hi mkissel1 ,

use IF and COUNTIF function to translate "OFF" to zero (0)
=IF(COUNTIF($C4:$M4,"OFF")>=0,0,"insert your formula here")

mkissel1

Copper Contributor

Jan 07, 2023

I am not sure where to put that equation...this is the excel file I am using:
https://www.planday.com/blog/free-employee-shift-schedule-excel/

Rodrigo_

Iron Contributor

Jan 07, 2023

I'm afraid I cannot get the file on your link, it said that it is not available on my country.
It would be great if you could give me a sample of the file you are using thru here or PM.

mkissel1
Copper Contributor
Jan 07, 2023
I will PM the file to you. Thank you for your assistance. I really appreciate it!