Adding small units of time and entering them quickly
 

I would like to add multiple small units of time. For eg 5sec + 10sec
+10sec etc and have them in the following format h:mm:ss. I would also
like to be able to enter the times in quickly. I have searched the
entering time tips but once I have used the formula suggested it will
not allow me to add them together. Any help would be much appreciated


--
ckdkvk
------------------------------------------------------------------------
ckdkvk's Profile: http://www.excelforum.com/member.php...o&userid=29245
View this thread: http://www.excelforum.com/showthread...hreadid=497828

Adding small units of time and entering them quickly
 

enter in your units of seconds as a general number and next to it have the
formula
=0&":"&00&":"&F6 adjust f6 for your actual input cell address and then sum
as required with the time format you require,but NOT the actual seconds input
cells


paul
remove nospam for email addy!



"ckdkvk" wrote:


I would like to add multiple small units of time. For eg 5sec + 10sec
+10sec etc and have them in the following format h:mm:ss. I would also
like to be able to enter the times in quickly. I have searched the
entering time tips but once I have used the formula suggested it will
not allow me to add them together. Any help would be much appreciated


--
ckdkvk
------------------------------------------------------------------------
ckdkvk's Profile: http://www.excelforum.com/member.php...o&userid=29245
View this thread: http://www.excelforum.com/showthread...hreadid=497828