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 ??


--
bengaluru
------------------------------------------------------------------------
bengaluru's Profile: http://www.excelforum.com/member.php...o&userid=24188
View this thread: http://www.excelforum.com/showthread...hreadid=384421