| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please HELP!!!!
Hello again,
Im 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
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" 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
no, there are no empty cells and if missing 8 hours will be a 0
-- Regards YM "T. Valko" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
Ok, try this:
=COUNT(H9:H83)*8-SUM(H9:H83) -- Biff Microsoft Excel MVP "Yitzhack" wrote in message ... no, there are no empty cells and if missing 8 hours will be a 0 -- Regards YM "T. Valko" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
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. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Ok, try this: =COUNT(H9:H83)*8-SUM(H9:H83) -- Biff Microsoft Excel MVP "Yitzhack" wrote in message ... no, there are no empty cells and if missing 8 hours will be a 0 -- Regards YM "T. Valko" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
T, Thank YOU so much!!
-- Regards YM "T. Valko" wrote: Ok, try this: =COUNT(H9:H83)*8-SUM(H9:H83) -- Biff Microsoft Excel MVP "Yitzhack" wrote in message ... no, there are no empty cells and if missing 8 hours will be a 0 -- Regards YM "T. Valko" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
that is correct, thanks again... thank you so much !!!
-- Regards YM "T. Valko" wrote: 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. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Ok, try this: =COUNT(H9:H83)*8-SUM(H9:H83) -- Biff Microsoft Excel MVP "Yitzhack" wrote in message ... no, there are no empty cells and if missing 8 hours will be a 0 -- Regards YM "T. Valko" wrote: 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please HELP!!!!
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Yitzhack" wrote in message ... that is correct, thanks again... thank you so much !!! -- Regards YM "T. Valko" wrote: 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. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Ok, try this: =COUNT(H9:H83)*8-SUM(H9:H83) -- Biff Microsoft Excel MVP "Yitzhack" wrote in message ... no, there are no empty cells and if missing 8 hours will be a 0 -- Regards YM "T. Valko" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
