"time" for a timesheet.

pjoaquin (Paul)

Thank you for that formula help, it works great. I would have sworn I tried one very close to that, but evidently not! One quick question in regards to the formula though. When I enter a time in column "F" (17:30 for instance) and before I enter a time into column "G", column "H" which contains the formula will display -17:30 until a time is entered into column "G". Is there a way I can keep anything from being displayed in "H" till the end time is entered into "G"?

Thanks again so much for your help! Formulas are my weak link! Thanks to you too Special-K, I tried your formula also, but gotta say pjoaquin's was pretty much right on to what I'm needing! Not to worry, I'll end up having lots more questions in the future and requests for help!
Steve

Thank you pjoaquin, this works excellent! Your help is much appreciated!