Formula counting time between two dates

[Zomo1985]

Hello!

I need serious help creating a formula that:

1. Calculates the time between two dates - submitted and printed I.e

Submitted date
03-Jan-2017 16:33:46
Printed date
04-Jan-2017 12:39:48

2. And secondly shows as passed if lower than 24 hrs, or failed if greater than 24hrs.


Thanks in advance for any help!!!

 

[Zomo1985]

Also need to take into account the weekends. This part has really stumped me....

 

[morningstar1001]

Without the weekend, it's easy to get printed date - submitted then convert to hours or minutes to measure.

I'm not sure if there is other way to make it easier.
But here the way I do it long time ago. I add a lot additional column to break down calculate the time in each day.
Then get sum to calculate the total duration between submitted & printed.

I6 = 13 Jul ; J6 = 14 Jul;
The formula calculate hour in 13 Jul is:
=IF((IF($D7>J$6,J$6,$D7)-IF($C7<I$6,I$6,$C7))*24<0,0,(IF($D7>J$6,J$6,$D7)-IF($C7<I$6,I$6,$C7))*24*I$5)

I add the row 5 to check the weekend by: =IF(OR(WEEKDAY(I6)=1,WEEKDAY(I6)=7),0,1)
So if that day = weekend, the duration = 0.

 

[morningstar1001]

Sorry my image link in previous post not work.

 

[morningstar1001]

I just realize the formula is corrupted. Here the full formula.
It check the start & end time to calculate the overlap duration, then * 24 to convert from day to hour.

=IF((IF($D7>J$6,J$6,$D7)-IF($C7<I$6,I$6,$C7))*24<0,0,(IF($D7>J$6,J$6,$D7)-IF($C7<I$6,I$6,$C7))*24*I$5)