Totaling Formulas

E

Eleanor

I used the formula =MOD(B1-A1,1), in a few cells and now I
want to add those specific cells together.

It isn't letting me do it.

Help!!

Thank You
Eleanor
 
N

Norman Harker

Hi Eleanor!

Sum in the normal way but if both A1 and B1 are times, format
[hh]:mm:ss

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top