ExcelBanter - How do I set up time tracking formulas?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up time tracking formulas? (https://www.excelbanter.com/excel-worksheet-functions/27060-how-do-i-set-up-time-tracking-formulas.html)

lisaw

How do I set up time tracking formulas?

I am trying to create a formula that will calculate employee vacation and
sick time used. Is anyone aware of a formula that will allow me to calculate
text for value??

Gary Brown

=if(or(A1="Vacation",A1="Sick"),8,0)
HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.

"lisaw" wrote:

I am trying to create a formula that will calculate employee vacation and
sick time used. Is anyone aware of a formula that will allow me to calculate
text for value??

All times are GMT +1. The time now is 11:23 PM.