The "IF" function with drop down boxes?

[zackn2hiq]

I have an "IF" question about drop down boxes including text and results in time format.
=if(drop box="Lunch",then daily total needs be "0") on a timesheet that accumulates time "in and out" through out a day for a daily total

Any help would be very much appreciated.

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=541946

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

Also, in your other thread, I see that you bumped your own thread less than half and hour after you posted it. You should usually wait a few hours at least before bumping your own threads, because once you do, it no longer shows up on the list of threads with no replies, so many users may miss it as being an unanswered thread.