Adding small units of time and entering them quickly

[ckdkvk]

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

[paul]

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