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

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

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/

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

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