Information générale
Titre:
Handling time in Excel VBA
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement