Assuming earlier time in A14 (3:45 am) and later time in B14 (11:15 am), then
in another cell = B14-A14
and now the trick: in that cell use Format --> Cells and go down to custom
and use [h]:mm:ss to give you the result in hours minutes and seconds rather
than as a time of day.
The answer is negative 8 hours. But Excel cannot display negative times. If
this is what you actually want to do, post back, and we'll give you some
options.
If you really meant 11:15 - 3:15, it's simple subtraction:
=a2-a1
Format as a time.
