Totaling Formulas

[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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.