View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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.?