Count time to time
 

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

Count time to time
 

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.?

Count time to time
 

10:00 AM in A1
3:00 PM in A2
=A2-A1, formatted as [h]:mm would show 5:00
If you want 5 as a number for further processing, then use =(A2-A1)*24 and
format as number or general.
--
David Biddulph

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