Setting up excel to calculate duration between 4 columns.

[sebc1985]

Hi everyone!

I am trying to set up my spreadsheet to display the duration between 4 columns per row.

Column A is for the date in.
Column B is for the time in.
Column G is for the date out.
Column H is for the time out.
Column I is to display the difference in days, hours, minutes.

I have done duration between 2 columns before but I don't know if It can be done with 4.

Any help would be greatly appreciated.

[sebc1985]

Attachment 650290

Ideally this is what it would look like.

[PaulM100]

Try this:

Please Login or Register  to view this content.

[sebc1985]

I have tried that but it is giving me a Num Error

https://1drv.ms/x/s!AuJ0bOFiqvRSkE8H...2aAza?e=M7KaSq

[PaulM100]

I had it wrong. Try this:

Please Login or Register  to view this content.

[sebc1985]

I had it wrong. Try this:

Please Login or Register  to view this content.

You sir are awesome. Thank you very much.

[PaulM100]

You are welcome. It that took care of your problem, please mark the thread as Solved from Thread Tools.