Hello

I am programming a macro in Excel 2002 that will be able to calculate the total time that it takes to complete a series specific tasks.

In one column, I have a list of data in the m/d/yy h:mm format which is the date and time at which the task was completed.

For instance:
A: 2/1/04 14:06
B: 2/1/04 14:10

The difference between A and B is 0:04:03 so it took 4 minutes and 3 seconds to complete task B.

What I need to do is sum up the total of time it took to complete all tasks and I have no idea as to what kind of variable I should use to do this. If I use a Date Time variable, eventually when the total time will be greater than 24 hours, it will go back to 0:0:00...

Can anybody help me with that?

Thanks

Nick