Forum Discussion

simont485's avatar
simont485
Copper Contributor
May 13, 2019

Excel

Hi   I have a Staff rota and I would like to create a list of staff availability based on date for staff who are not on shift or have booked holiday. I NEED TO SHOW STAFF WHERE CELLS IN COLUMN C a...
excel
Gourab Dasgupta's avatar
Gourab Dasgupta
Iron Contributor
May 13, 2019
please create a sample excel with manual input (indicating your result)
  • Gourab Dasgupta's avatar
    Gourab Dasgupta
    Iron Contributor
    May 13, 2019
    what is the purpose of c column, how did you get the number 12, 45, 0 ....
    • simont485's avatar
      simont485
      Copper Contributor
      May 13, 2019

      Column C is an overtime count in hours.....so it will increase as more overtime is done.

       

       

      • Gourab Dasgupta's avatar
        Gourab Dasgupta
        Iron Contributor
        May 13, 2019

        simont485 

         

        why this four person in this list?

        So for 
         02/01/2001
        Person 60
        Person 80
        Person 1012
        Person 724

Resources