Since so much time has gone by, you may have found a way around this on your own, but here's my 2 cents.

Any time I have to deal with dates and times I break it down into seperate variables. In other words I would have the date and time broken down into the date, the hour and the minutes. Then do my calculations with integers. When finished, put it back together if need be. I did somethings with birthdays one time and even broke down the month, day and year. HIH


>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