+ Reply to Thread
Results 1 to 2 of 2

"Average" with error DIV/0

  1. #1
    agenda9533
    Guest

    "Average" with error DIV/0

    Taking average from data below I get DIV/0 Error

    J42=AVERAGE(J40:J41)

    J40 00:16:40
    J41 00:09:53
    J42 #DIV/0!

    Thank you

  2. #2
    Dave O
    Guest

    Re: "Average" with error DIV/0

    I suspect the entries in J40 and J41 are text entries, rather than
    numeric. Test for this by entering the formula =ISNUMBER(j40) in an
    open cell. If you get a FALSE response, then you can write a formula
    =TIMEVALUE(J40) that will translate the text cell into a time.
    Remember to format the TIMEVALUE cell with a time format.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1