| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF validation for time totaling
Hi,
Am Fri, 21 Dec 2012 17:17:32 +0000 schrieb JSmitty: 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. try: =IF(D15=0,0,Your Formula) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
Quote:
=IF(D15="",0,InsertYourForumlaHere) Last edited by Spencer101 : December 21st 12 at 10:45 PM |
| Reply |
| 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 | |||
Linear Mode
