Time Question

[jolson120499]

I am using powerpivot and I want to do a calculation on time
So for example
I have an orginal time 5:00 am and an update time of 7:00 pm
I would like to compute the difference between the two in hours and minutes

Then I want to send it to a pivot table and compute average difference.

When I have been trying this it keeps giving me an error message related to text.

Any help
All I want is a table with my categorical variable and average time difference

 

[Roderick_E]

it sounds like your source cells AREN'T really values or timevalues but merely text. Test that theory.

 

[FDibbins]

it sounds like your source cells AREN'T really values or timevalues but merely text. Test that theory.

how?

To test to see if the cell contains real time or just text looking like time, use this...

=isnumber(a1)
where A1 is a cell with your time
TRUE indicates real time, FALSE indicates text