Hi,
I have a payroll worksheet with 7 columns (among others) representing the days of the week. Time values are totaled,SUM, in the 8th column, no problems. I need to track any of three others variables within the daily cells, these are "V" (Vacation),"P" (Personal),"H"(Holiday). Each of the three text have their own column. I am trying to write a formula to total only the text cells using an 8 hr format i.e if C3=8V and F3=8V then K3=16. Likewise if C4=8V and H4=8H then K4=8 and M4=8 and so on. I hope I haven't totaly confussed everyone. I also would like to add shading to these formulas if possible but will be satisfied to attempt that at a latter date.
Help would be greatly appreciated, but I still just like to come here and read how you all help everyone else...
Thanks...Scott
I have a payroll worksheet with 7 columns (among others) representing the days of the week. Time values are totaled,SUM, in the 8th column, no problems. I need to track any of three others variables within the daily cells, these are "V" (Vacation),"P" (Personal),"H"(Holiday). Each of the three text have their own column. I am trying to write a formula to total only the text cells using an 8 hr format i.e if C3=8V and F3=8V then K3=16. Likewise if C4=8V and H4=8H then K4=8 and M4=8 and so on. I hope I haven't totaly confussed everyone. I also would like to add shading to these formulas if possible but will be satisfied to attempt that at a latter date.
Help would be greatly appreciated, but I still just like to come here and read how you all help everyone else...
Thanks...Scott