I am attempting to add my project hours in MS Excel. Column A is
start time (ex. 11:00am with "time" format), column B is stop time
(ex. 2pm with "time" format). I want column C to take the difference
between columns A and B and put it into Column C. For the given
example, column C should be 3. It tried the following solutions:
1. = B2-A2+IF(A2B2,1)
2. = B2-A2

Additionally, when press "Enter" to compute the formula, #VALUE!
appears in box. How can get the difference to come out correctly?

Thanks,

Steve