We help IT Professionals succeed at work.

Excel averaging time cells, get 0 or Div error.

cdb424ttm
cdb424ttm asked
on
Excel averaging time cells, get 0 or Div error.  Can someone please help me on why I'm getting these error and what I can do to fix it?  See attached file.
Book1-time-errors.xlsx
Comment
Watch Question

Finance Analyst
CERTIFIED EXPERT
Commented:
Your times in columns L to Q are text rather than true time.

You can convert using VALUE("TEXT") and copy paste values back over the original.

Thanks
Rob H

Author

Commented:
Thanks for the fast service

Explore More ContentExplore courses, solutions, and other research materials related to this topic.