I have searched the forum, but admit to having given up when all the similar-sounding problems/solutions I looked at did not seem to apply to my issue.

I have two times I want to calculate the difference from: A1 is the time a person went to sleep (ex. 10:43 PM); A2 is when the person woke up (ex. 6:00 AM). Since these times span from one day to the next, I am finding myself unable to create a formula that properly returns the result (A3) of 7:15.

I have formatted A1 and A2 as "Time, 1:30 PM."
I have formatted A3 as "Custom, hh:mm."

What is the correct formula I need to obtain the result I desire? Can I do this in a way that assumes the hours slept does *not* exceed 24 hours [i.e.: without having to specify dates in addition to the times]?

Thanks for your help in this.

--John