Excel Sick Days / Half Days

Originally Posted by Pixie_1

Hiya

I've been working on the attached spreadsheet and have it working almost perfectly, problem is that I need to be able to do half day E.g 0.5 and 0.5 makes 1 day. (:P)

I have no idea how to do this

Could someone help me by having a look at the spreadsheet and lettin me know?

Thanks in Advance

Pixie

you can simply add them like this
=A1+B1
or for a range
=SUM(A1:G1)

from attached file, its not clear that where are the numbers and where you want to add them up.
however according my understanding of your problem I have made a formula in cell C6 of 1st Qrt.
you can use it to add 0.5+0.5 (H, P or S) to one.

hope this would help you.

Hi,

Among many possibilities, my suggestion would be to use Upper case for full days and Lower case for half days ...

You will need to use a different code to denote full or half days

For example instead of using just H use Hf (full day) & Hh (half day)
You could use sinle letter codes as long as you had 1 for full days & a different one for half days

Formula for C6 would look like this

=COUNTIF($F6:$BS6, "Hf")+(COUNTIF($F6:$BS6, "Hh")/2)

Originally Posted by Pixie_1

Thank you very much

I've got it working now.

Thanks for the quick reply :D

you're welcome in Excel Forum.