Suming up a Split second timing

  • Thread starter Thread starter evo
  • Start date Start date
E

evo

If I have a time of 01:22.45 , which is mm:ss.00, how do i add th
values of the mm (which has to be * 60 secs), ss and the .00 into a ne
cell which is total of the )1:22.45. Which is 82.45. No problems addin
the mm and ss. but its the split second that gets me.

Thank
 
Evo,

Just create a custom format of [ss].00 and sum as normal.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks, it worked like a charm. But now the fx bar shows 12:01:36 AM
Excel is automatically converting my summed up times into this tim
format. Is there a way to switch it off? keep it as a numerical data?

Thanks
 
Back
Top