Summarizing Time Receipt

Hi guys!! Thanks in advance to have a look on my issue!!

I am really exausted to try, so I decided to ask for the good ones!
I have to sum the hours that our resouces worded during some Work Order (IDOF)
The same Resource can Sart and End the task many times, so the guys must inform which IDOF they are working on, his Name also the Status: Started or Ended

By the end of Work Order I have to check the total time to make sure if I got profit or loss with the estimated time. When I insert the IDOF the Excel must to show me for Each resourse the total worked time.

Best Regards
Luis
TimeReceipt.png

Try this:

Formula:

Please Login or Register  to view this content.

Good luck!

Thanks for your reply Keebellah!
I cannot do like that beacause the Date column comes in only one column from the Access than I have to summarizing the data from this column otherwise I have to filter and copy paste to the new column that you created!
Luis

Thank you so much Estevaoba!!!!!!!!!!!!!!!!!!!
Works like that.
I am using Office365 so, where there is comma, I just replaced to ";"

You're welcome, Luis.
I'm glad to help.
Thank you for the rep point added.

Take care and stay safe.