Calculate Difference Between Two DateTimes and Sum Up the Difference

[RonGatmaitan]

Hi all,

I have a table that has a few fields and three of them are - employee, task start date and task end date. I basically have to get how long it takes for an employee to finish a particular task, and then sum up the time spent to accomplish all their tasks for a particular period. Ideally, the format should be in HH:MM:SS. Do note that the hours may exceed 24 hours, so I may not be able to use the time format. Best and simplest way to do this, please.

Thank you.

Ron

[binu_acs]

One way of doing this the the DateTimeDiff function

[RonGatmaitan]

Thank you very much, @binu_acs! I would have loved to have it in a format where all the employees' total could be summed up in Excel, but this will do. :) Again, thank you.