| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF validation for time totaling
Hi, I want to have a validation on a time sheet that if the lunch time is not entered then the daily total will not calculate.
The lunch time is entered in cell D15, the daily total is in cell D16. I need an IF validation that states if D15 is 0 then D16 will not total and be 0. D16 currently has a formula to add the times from the entire day together. Just can't figure this one out, any ideas? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| totaling time in 2 cells w/ total of hours worked in 3rd | Excel Discussion (Misc queries) | |||
| data validation, totaling values based off dropdown lists | Excel Discussion (Misc queries) | |||
| Totaling Time (Text) | Excel Discussion (Misc queries) | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
