Hi there,

Anyone able to tell me how to add times minutes and seconds so that the
answer will show hours minutes and seconds. Any hints on the best way to
format the cells to show times would be great.

Thank you!
--
Bobby

Say

A1 = 11:30:10
B1 = 15:30:10
C1 = =SUM(A1:A2) = 27:00:20


More help on time on the attached link

http://www.cpearson.com/excel/datetime.htm


VBA noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56879

Sorry

Forget to say to format sum cell as [H]:MM in custom formats

VBA noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568796

Hey Noob, Thanks. #Why did I think it waz so much more complicated. I had
looked at the website but confused myself.

Good place this. thanks again
--
Bobby


"VBA Noob" wrote:

>
> Sorry
>
> Forget to say to format sum cell as [H]:MM in custom formats
>
> VBA noob
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=568796
>
>