Help with Date & Time Formula Please

[Anapfon]

Hi guys, I've been trying to find a solution to my issue for a while and had no success. I have a report with a number of different transactions to the same product and I need to figure out how long it took to complete the transaction for each product. Also, I'd like to exclude weekends. The spreadsheet I'm working with looks like this:

Any help will be greatly appreciated!

Thanks!

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[Ashhu]

Hello Anapfon,
Welcome to group.
i understand from your question that you want to measure time taken by each product. using Nebu date solution i have updated sheet with table(I:L), please check whether i understood your requirement correctly. though i am unable to fix weekend issue.
thanks to @Khalid NGO for coming up with date formula.

 

[Anapfon]

Morning everyone!

I tried the date+time formula that you guys used to start the whole thing ( =DATE(RIGHT(B4,4), MID(B4,4,2), LEFT(B4,2))+C4 ) but I'm only getting the date... any idea of why it's not pulling the time? I even tried to paste in a brand new spreadsheet but it didn't work... Thanks!

 

[Anapfon]

Don't worry, I figured it out! It was just formatting. Will try the other formulas! Thank you so much guys!!!

 

[Anapfon]

Hello guys, I sort of managed to get the time I wanted with your amazing help =) now all I need is to remove the weekends of the time displayed in column D. Does anyone know how to do it pleeeeeeeeeeease? Thanks!

 

[Nebu]

Hi:

Use the following formula.

=NETWORKDAYS(B2,C2)-1-MOD(B2,1)+MOD(C2,1)

Thanks

 

[Anapfon]

Hi:

Use the following formula.

=NETWORKDAYS(B2,C2)-1-MOD(B2,1)+MOD(C2,1)

Thanks

You are awesome!!! Thank you so much!!