The Ending time is the larger number, you subtract the starting time
from the ending time to get the number of hours worked. As to your
example. Subtracting 9 from 12 will give you 3 hours worked, not 5, and
if you subtract 12 from 9 you will have a negative 3, not 5. Now on the
other hand if you really meant 2pm instead of 12, then it is really 14
not 2, and subtracting 9 from 14 will give you 5!

vrsantana wrote:

How so? Not sure I get what you are trying to explain. How is subtracting,
for example, 9 from 12 going to give me a value of 5?

"Bob I" wrote:


You have to subtract the "Start time" from the "End time", you currently
are trying to do it backwards.

vrsantana wrote:


I created a spreadsheet that I use to make my employee schedule. I would
like to add a column to give me a running total of the hours for each
particular person. I can't seem to figure out how to tell excel that for
example if I have 9-2 in a cell, that I want that cell's value to be 5. Will
I have to create a formula for every combination of hours and what each value
is?