Calculate Difference Between Two DateTimes and Sum Up the Difference
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
RonGatmaitan
8 - Asteroid
‎08-20-2022
02:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Best Practices
- Date Time
- Developer
- Optimization
2 REPLIES 2
binuacs
21 - Polaris
‎08-20-2022
03:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-20-2022
10:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much, @binuacs! 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.
