View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default formula in excel to track times between two different dates ?

On Mon, 20 Feb 2006 20:42:11 -0800, bmg wrote:

i want to figure out the hours between two different times even if they go
into the next day ?


A1: 2/6/06 7:00
A2: 2/9/06 4:45

=A2-A1

Format/Cells/Number Custom Type: [h]

--69


--ron