You can just subtract one from the other, i.e.

=B1-A1

format as time.

If your start time might be before midnight and end time after you should use

=B1-A1+(A1B1)

"itsagoodlife" wrote:

How do I get the varience/hours between say 10:00 AM to 3:00 PM = 5 hrs.?