Hi

Why not enter StartTime in colomn A and EndTime in column B, then calculate
working hours in column C with this formula: =B1-A1

All columns to be formatted as time.

BTW: Format the cell for total working hours as costum [t]:mm to have the
cell show more than 24 hours.

Regards,
Per

"vrsantana" skrev i meddelelsen
...
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?