hh:mm:ss average problem

stdar2

New Member
Joined
Apr 10, 2020
Messages
4
Office Version
365
Platform
Windows
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.
 

Attachments

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,080
Office Version
365
Platform
Windows
Hi. I cant see any divide by zero error on what you have shown us.
 

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,542
Most likely, your times are text strings. Try converting them into Excel times by using "Text to Columns".
 

stdar2

New Member
Joined
Apr 10, 2020
Messages
4
Office Version
365
Platform
Windows
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

New Member
Joined
Apr 10, 2020
Messages
4
Office Version
365
Platform
Windows
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
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,080
Office Version
365
Platform
Windows
Just click the column press text to columns and then finish.
 

stdar2

New Member
Joined
Apr 10, 2020
Messages
4
Office Version
365
Platform
Windows
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!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,622
Messages
5,469,762
Members
406,668
Latest member
ElizaR

This Week's Hot Topics

Top