Are there any empty cells within the range and if so how should they be
handled? Should an empty cell be counted as missing 8 hours?

--
Biff
Microsoft Excel MVP


"Yitzhack" wrote in message
...
Hello again,

I'm working on a project where I need to calculate the hours missed per
day
on a daily basis. The workbook needs to record every employee (70+)
working 8
hour shifts, on column H9 through H83 but if an employee comes late 2
hours
only 6 hours will be entered and so on . The hours worked are entered
manually but I need a formula in cell H85 that returns the total hours
missed
per that day.

Thanks for the help

--
Regards
YM