Time issue

[james rockford]

Hello to all.....

I am look to find the sum between to times but the issie is i have part of the time were we need to subtract a value IE....
from 12:00 am to 6:45 Am will be remove for the totals...so if i have a start time of
11:45 to 8:45 Am i will need to count the time from 11:45 to 12:00 Am then subtract the time from 12 to 6:45 am and then start counting again at 6:45 am....this will look like 2:15
Can some one help with a forumla....thanks

Note please e-mail me at [e-mail address removed]

Thanks and i hope this is clear

 

[Dannyh1]

Hi

What you want the result to be if times where 11:45 to 05:45?

 

[james rockford]

Hi Dannyh1...the start time will always be 6:45 am......so the time from 12: pm to 6:45 am
is the problem this time will not count in the totals

 

[Dannyh1]

Will this work:

Fixed:
A1 = 12:00
A2 = 06:45

Variable
B1 = 11:45
B2 = 08:45

Formula:

=IF(AND(B1 < <A1,B2>A1, B2 > A2),(A1-A2)-(B1-B2),0)

 

[james rockford]

Thanks dan.....that works great ......have a great week.....