If A1 (11:00 pm) is bigger than B1 (7:00 am), thanadd onedayto B1 (7:00 am), and only after that subtract it from 11:00 pm. However, if that's not the case, than simply do B1 - A1 When you are done, multiply my total by 24. Method C: =(B1-A1+(B1<A1))*24 You ...