Hello!
I'm running into an issue when adding up my clients total hours at the end of the month.
The excel sheet is currently exported from Monday, with time tracked within the Monday platform. Attached is the CSV file that gets exported, which is currently organized by task.
The issue is, the desired total hours should not be all the hours added up by individual employees, but should be our company's total hours spent - so no overlap if two people are working at the same time.
For the moment, I went in manually and reorganized the sheet by date then cross referenced the time and deleted any overlapping hours, but there has to be a more efficient way to do this.
For example, here is a snippet of the data:
Since these two were happening at the same time, the desired total hours worked in the above case should be 4hrs 9m 25s, not 4hrs 57m 7s (4hrs 9m 25s + 0hr +47m+42s)
Please let me know if there is any solution to this or any suggestion that could make the desired outcome easier, I'm not sure if this is something I can achieve in Excel or through my time tracking management software.
Thanks!!
I'm running into an issue when adding up my clients total hours at the end of the month.
The excel sheet is currently exported from Monday, with time tracked within the Monday platform. Attached is the CSV file that gets exported, which is currently organized by task.
The issue is, the desired total hours should not be all the hours added up by individual employees, but should be our company's total hours spent - so no overlap if two people are working at the same time.
For the moment, I went in manually and reorganized the sheet by date then cross referenced the time and deleted any overlapping hours, but there has to be a more efficient way to do this.
For example, here is a snippet of the data:
2021-09-06 | 2021-09-06 | 11:26 AM | 3:36 PM | 4h 9m 25s |
2021-09-06 | 2021-09-06 | 12:58 PM | 1:46 PM | 47m 42s |
Since these two were happening at the same time, the desired total hours worked in the above case should be 4hrs 9m 25s, not 4hrs 57m 7s (4hrs 9m 25s + 0hr +47m+42s)
Please let me know if there is any solution to this or any suggestion that could make the desired outcome easier, I'm not sure if this is something I can achieve in Excel or through my time tracking management software.
Thanks!!
Attachments
Last edited: