hh:mm:ss average problem

[stdar2]

hello,

I have data that present at hh:mm:ss eg 00:01:52 but when I try to average I get the DIV error and when I try to sum it comes out as 00:00:00 I have tried the different formatting but nothing changes.

 

[steve the fish]

Hi. I cant see any divide by zero error on what you have shown us.

 

[Tetra201]

Most likely, your times are text strings. Try converting them into Excel times by using "Text to Columns".

 

[stdar2]

Most likely, your times are text strings. Try converting them into Excel times by using "Text to Columns".

Hey, when I use the text to colums it only give me general, text or date no time?

 

[stdar2]

Hi. I cant see any divide by zero error on what you have shown us.

I only give you guys snap shot but the DIV is more when I attempt to pull the detail into a pivot and average the field

 

[gaz_chops]

Use Date, h:m:s are simply fractions of a day.

 

[steve the fish]

Just click the column press text to columns and then finish.

 

[stdar2]

Most likely, your times are text strings. Try converting them into Excel times by using "Text to Columns".

You were right!! I used TIME VALUE and it done the trick, thank you!!!

 

[Tetra201]

You are welcome. Glad to have helped.