Adding unformatted time like 0:00:00 using VBA

[l33tn4]

ok so i need VBA to add time when it is formatted as 00:00:00 (e.i. hours:minutes:seconds) and output a total value. Normally i would have some code to show but with this one i just don't know where to start. any ideas or help would be nice.

 

[shg]

msgbox format(worksheetfunction.Sum(range("A1:A10").value), "h:mm:ss")

 

[l33tn4]

ummm that might work but i am getting very specific information using a number of loops and if then's. so i would have to be in a way in which i could be out in a loop like x = x + 1 is kind of the method that i always use. having a variable that is constantly being add to each other. any ideas? if not i was just going to break down each part add them together and into time notation over the loop is over.

 

[James Snyder]

Have you looked at the DateAdd function?

 

[shg]

... but i am getting very specific information using a number of loops and if then's.

I could do no more than guess what what you're trying to do. Perhaps instead you could explain it.