| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm trying to count sick and vacation days
I've used the count formula to count the number of dates entered in a column,
but how do I account for 1/2 days? Any suggestions? Maybe another formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to count sick and vacation days
And how are 1/2 days specified in your data?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kevin" wrote in message ... I've used the count formula to count the number of dates entered in a column, but how do I account for 1/2 days? Any suggestions? Maybe another formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to count sick and vacation days
How do you designate 1/2 days? Just count those and add that count to your
original count.... -- Brevity is the soul of wit. "Kevin" wrote: I've used the count formula to count the number of dates entered in a column, but how do I account for 1/2 days? Any suggestions? Maybe another formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to count sick and vacation days
..5 is how I designate half days, the count formula only returns a whole
number, namely 1. "Dave F" wrote: How do you designate 1/2 days? Just count those and add that count to your original count.... -- Brevity is the soul of wit. "Kevin" wrote: I've used the count formula to count the number of dates entered in a column, but how do I account for 1/2 days? Any suggestions? Maybe another formula? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to count sick and vacation days
I specify 1/2 days as a date with an asterisk.
"Bernard Liengme" wrote: And how are 1/2 days specified in your data? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kevin" wrote in message ... I've used the count formula to count the number of dates entered in a column, but how do I account for 1/2 days? Any suggestions? Maybe another formula? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to count sick and vacation days
Use the COUNTIF function, count up your half days, multiply the number
by 0.5, add this to the result of a second COUNTIF function. =COUNTIF(A2:A50,0.5)*0.5+COUNTIF(A2:A50,1) Hope this helps, David On Jan 24, 10:43 pm, Kevin wrote: .5 is how I designate half days, the count formula only returns a whole number, namely 1. "Dave F" wrote: How do you designate 1/2 days? Just count those and add that count to your original count.... -- Brevity is the soul of wit. "Kevin" wrote: I've used the count formula to count the number of dates entered in a column, but how do I account for 1/2 days? Any suggestions? Maybe another formula?- Hide quoted text -- Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to count sick and vacation days
=COUNTA(A1:A100)-COUNTIF(A1:A100,"~*")/2
"Kevin" wrote: I specify 1/2 days as a date with an asterisk. "Bernard Liengme" wrote: And how are 1/2 days specified in your data? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kevin" wrote in message ... I've used the count formula to count the number of dates entered in a column, but how do I account for 1/2 days? Any suggestions? Maybe another formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| template to track sick and vacation time for a year | Charts and Charting in Excel | |||
| Keeping track of Sickdays, Vacation days, and hours for each. | Excel Worksheet Functions | |||
| How do I track vacation days on Excel? | Setting up and Configuration of Excel | |||
| Count Function | Excel Worksheet Functions | |||
| Formula for a time card | Excel Worksheet Functions | |||
Linear Mode
