Please HELP!!!!

[Yitzhack]

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

 

[T. Valko]

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?

 

[Meebers]

Unless I am not understanding your problem...but enter into i.e. column I an
8 adjacent to all workers. In column j subtract the hours worked from 8 to
give you missed hours. Total that column and in H85 point it to that total
i.e. =j85 or where ever you total the missed hours.

 

[Yitzhack]

no, there are no empty cells and if missing 8 hours will be a 0
--
Regards
YM

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?

 

[T. Valko]

Ok, try this:

=COUNT(H9:H83)*8-SUM(H9:H83)

--
Biff
Microsoft Excel MVP

no, there are no empty cells and if missing 8 hours will be a 0

 

[T. Valko]

P.S.

=COUNT(H9:H83)*8-SUM(H9:H83)

I'm assuming the hours entered are integers like 8 and not time values like
8:00.

 

[Yitzhack]

T, Thank YOU so much!!
--
Regards
YM

Ok, try this:

=COUNT(H9:H83)*8-SUM(H9:H83)

 

[Yitzhack]

that is correct, thanks again... thank you so much !!!

 

[T. Valko]

You're welcome. Thanks for the feedback!