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?