Hive Mind...
I'm setting up a scheduling worksheet in Excel. I'm done except for one function. I have a daily hour total derived with the formula =TIME(CELLB-CELLY, "h:mm"). I want to calculate daily total hours by taking that number less a single numerical value used to represent lunches.
I would have though it was simple as +derivedvaluecell-lunchvaluecell. Nope. There's obviously a step I'm missing to have Excel treat the daily hour total as a single number for purpose of the net daily time calc, but I can't for the life of me figure out what it is.
Thoughts?
Brad