I would like help with a formula to solve the following
Cell A:1 = 7:30am Cell A:2 = 14:00
I want Cell A:3 to equal cell A:2 - A:1 but if the time spans 12:00 to 12:30 then to deduct the 30 minutes from the total time in cell A:3
Your help appreciated
Cell A:1 = 7:30am Cell A:2 = 14:00
I want Cell A:3 to equal cell A:2 - A:1 but if the time spans 12:00 to 12:30 then to deduct the 30 minutes from the total time in cell A:3
Your help appreciated