It would be useful if you showed us the formula you were using.

Excel treats times as numbers, so all arithmetic operations work on them,
including Sum.

Regards,
Fred.

"Wet Nose" <Wet wrote in message
...
I have created a work schedule with start/end time cells formated hh;mm
AM/PM. The "total hours scheduled" cell is formated [h]:mm. I need a
formula for the "total" cell that will add the weekly shifts. Ex; Monday
10-5 + Tuesday 12-8 etc. equals 15:00 I've tried to SUM (time out-time
in)
and it will work for one day, but I can't figure out how to add the
remaining
work days - all it get is errors. Please help!