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)

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

Thanks


---
Message posted from http://www.ExcelForum.com/