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