Forum Discussion

mkissel1's avatar
mkissel1
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_'s avatar
    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")

Rodrigo_'s avatar
Rodrigo_
Iron Contributor
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's avatar
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_'s avatar
    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's avatar
      mkissel1
      Copper Contributor
      Jan 07, 2023
      I will PM the file to you. Thank you for your assistance. I really appreciate it!

Resources