I have an attendance tracking spreadsheet in which I need to track the number
of hours as well as the type of absence, i.e. due to illness, military leave,
FMLA, etc., rather than just the number of days the employee is gone.

I have the spreadsheet set up with by the employees name in the rows and
then have set up columns for each day of the year and columns for the reason
of the absence. Each time there is a military absence, the manager will put
an "M" under the date and excel will then automatically count the number of
times "M" is under that persons name throughout the year. This formula is
working great! However, as mentioned above, I need it to count hours, not
days. How can I set up the formula to allow me to enter in a number of hours
as well as "M" in a single cell and have the total automatically calculated
for me?

Currently looks like the following:

Days of Absence
Employee name: Military "M" FMLA "F" 010106 010206
John Doe 1 1 M F


I want it to look like:

Hours of Absence
Employee Name: Military "M" FMLA "F" 010106 010206
John Doe 8 4 8M 4F

Is this possible without adding additional columns for the hours?