Adding times Bobby 06.08.2006 20:01:01 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

Re: Adding times VBA Noob <VBA.Noob.2c4xb5_1154895309.3396[ at ]excelforum-nospam.com> 06.08.2006 20:14:35 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 noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=568796

Re: Adding times VBA Noob <VBA.Noob.2c4xjh_1154895609.0603[ at ]excelforum-nospam.com> 06.08.2006 20:19:06 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?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=568796

Re: Adding times Bobby 06.08.2006 22:09:01 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: [Quoted Text] > > 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?action=getinfo&userid=33833 > View this thread: http://www.excelforum.com/showthread.php?threadid=568796 > >