Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I add words, holiday =1, holiday am=0.5
I am trying to set up a holiday spreadsheet for work and I have got it so it
adds up all the words holiday to say how many days each employee has taken but I need to to add up the holiday AM and holiday PM as 0.5. Does anyone know the formula to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I add words, holiday =1, holiday am=0.5
=SUMPRODUCT(--((EXACT(E1:E20,"hAM"))+(EXACT(E1:E20,"hPM"))))*0.5 +COUNTIF(E1:E20,"h")
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GCC" wrote in message ... I am trying to set up a holiday spreadsheet for work and I have got it so it adds up all the words holiday to say how many days each employee has taken but I need to to add up the holiday AM and holiday PM as 0.5. Does anyone know the formula to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I add words, holiday =1, holiday am=0.5
GCC,
Try: =COUNTA(G1:G10)-SUM(--(RIGHT(G1:G10,2)={"AM","PM"}))/2 Array entered with Ctrl + Shift Enter or =COUNTA(G1:G10)-SUMPRODUCT(--(RIGHT(G1:G10,2)={"AM","PM"})/2) Entered normally -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "GCC" wrote in message ... I am trying to set up a holiday spreadsheet for work and I have got it so it adds up all the words holiday to say how many days each employee has taken but I need to to add up the holiday AM and holiday PM as 0.5. Does anyone know the formula to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Happy Holiday | Excel Discussion (Misc queries) | |||
Holiday Planner show holiday taken? | Excel Worksheet Functions | |||
Holiday Dates | Excel Worksheet Functions | |||
Holiday Pay | New Users to Excel | |||
Holiday chart | Excel Worksheet Functions |