Richard,

I use a lower case l for half-day, upper-case L for a full-day and then
count them with

=SUMPRODUCT(--(ISNUMBER(FIND("L",D1:D20))))+=SUMPRODUCT(--(ISNUMBER(FIND("l"
,D1:D20))))/2

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RGayle_Imperial" wrote in
message ...
I am trying to create a spreadsheet showing annual leave in a workbook. I
have used countif to calc number of days. but how do i show half days
using
formulas.

many thanks

Richard.Gayle