On Mon, 4 Jul 2005 20:00:33 -0500, bengaluru
wrote:


Hi guys,

I am trying to add up the time in one of my rows. How do I do that ??

For example I have the following times in my row E

E2 10.15
E3 1.25
E4 4.45
E5 2.15


The Total will now be 18 hrs 40 minutes ( adding manually)

But how I do that in Excel to get the right number of hours and
minutes. I did try to format the cells as Time. But the result is
something weird.

Any help ??

If your "." is the time separator in your locale, then you can merely SUM the
column.

If your "." is the decimal separator, and not the time separator, then try this
array-entered formula:

=SUM(--SUBSTITUTE(E2:E5,".",":"))

To array-enter a formula, after typing of pasting it into the cell, hold down
<ctrl<shift while hitting <enter. XL will place braces {...} around the
formula.


--ron