Your formula isn't valid syntax. If you've got a formula in your
spreadsheet it's safest to copy it from the formula bar to the newsgroup,
rather than retyping it with errors.

Did you mean =SUM((A6-A5)*24,(A4-A3)*24) ?

If your problem is with going beyond midnight, it's worth using the
MOD(...,1) construct.

Try =24*(MOD(A6-A5,1)+MOD(A4-A3,1))
--
David Biddulph

"Caramon6561" wrote in message
...
I have a third shift and using excel to calculate time 10:30 to 7am all the
other shifts calculate fine useing =sum((A6-A5)*24(A4-A3)*24), But useing
this formula the third shift comes out in negative numbers any
suggestions.