I am looking for a formula to look in times in A1 and A2 (A1 has start time and A2 has finish time and tell me how much of that time crosses over the hours between 1800 and 0600
Example
A1 = 2200 A2= 0800 answer would be 8 hours
Any help appreciated
Example
A1 = 2200 A2= 0800 answer would be 8 hours
Any help appreciated