Finding the difference between times

  • Thread starter Thread starter Nan
  • Start date Start date
N

Nan

I am trying to find the difference between 2 times. In cell C4 I hav
8:10 am and in cell E4 I have 8:30 am. In cell F4 I have the formul
TEXT(E4-C4,"h:mm"). My problem is that now I want to be able to fin
the average of the results found in column F. When I use the AVERAG
function it doesn't work (I'm assuming because my results are in tex
format. How can I get the average of column F??

Any help is appreciated. Thanks
 
I am trying to find the difference between 2 times. In cell C4 I have
8:10 am and in cell E4 I have 8:30 am. In cell F4 I have the formula
TEXT(E4-C4,"h:mm"). My problem is that now I want to be able to find
the average of the results found in column F. When I use the AVERAGE
function it doesn't work (I'm assuming because my results are in text
format. How can I get the average of column F??

Any help is appreciated. Thanks.
Click to expand...

Don't use TEXT(). Just use the formula =E4-C4 and give the cell the custom
number format [h]:mm.
 
Back
Top