Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figuring total # of hours between multiple times
I am creating a work schedule template that will total the number of hours an
individual is scheduled to work for the week. The template will reflect the work schedule for two weeks for a number of individuals. I have entered a formula that will calculate the total if the cell contents are all time values. My problem is that any given day can have "OFF", "VAC" or "HOL" in one of the cells. This returns a "#VALUE!" error. Is there any way to imbed an additional formula to ignore any cells with text or even with the specific values listed above. Here is a copy of the information I am working with: 15-Jul 16-Jul 17-Jul Hours 06:00 16:00 07:00 16:00 OFF #VALUE! The formula enter is: =((K3-J3)*24)+((M3-L3)*24)+((O3-N3)*24) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate total pay from pay rate times hours and minutes | Excel Discussion (Misc queries) | |||
In Excell how can i get a total hours worked value from 2 times? | Excel Worksheet Functions | |||
multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
Figuring hours | Excel Worksheet Functions | |||
Figuring military time for total hours | Excel Worksheet Functions |