Excel 2010 employee absence schedule issue

Hi

I downloaded Employee Absence Schedule from the microsoft templates site and is good apart from I want to enter a half day value in the spreadsheet

For example when I press P, it enters a value of 1 in the July total row but I want to change the value to 0.5 so is a half day value of 0.5 when I press P for Personal

I can't work it out, not sure if is a formula etc

I can attach the excel file to a message if need be

Thank you in advance

Kind regards

Ian

Need to attached that sheet, but you can do divided by 2 to total count of half day.

Regards,
Suhas

Need to attached that sheet, but you can do divided by 2 to total count of half day.

Regards,
Suhas

Hi

Thank you so much for the reply, appreciate it

I have attached the spreadsheet to this message

I can't work out where to put the divide the total count by 2 to get the half day for that key as don't need it on all of them

Changes made in Column AG formula.

Regards,
Suhas

Thank you for the change, really appreciate it

Is it ok to quickly change the rown that says July Total so when a half day is entered it displays 0.5 instead of 1

Is that possible?

Suhas,
I have the same problem but cannot download your file above?
Can you let me know how to change from 1 to .5

Please find below formula: add this is in the cell: AG5
=COUNTA(tblJanuary[[#This Row],[1]:[31]])-COUNTIF(tblJanuary[[#This Row],[1]:[31]],"H")/2

Hi All,

Using the same template, how could be possible to add new colors and type of absences to the Color Key row (12)?

Thanks in advance.
Regards
Antonio