Need Excel to Numbers formula help (pic)

Discussion in 'Mac Apps and Mac App Store' started by Julien, Apr 16, 2009.

  1. Julien macrumors G3

    Julien

    Joined:
    Jun 30, 2007
    Location:
    Atlanta
    #1
    I keep a simple spreadsheet of my cardio/time/calories for each month. I switched from Excel to Numbers but my formula for filling down and adding time doesn't work. What do I need to change to make it work?

    [​IMG]
     
  2. Mal macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #2
    Try switching to absolute references (so =B3+C2). That, or it may be finding an =Time function that's interfering, in which case you need to define the function and put the cell references in parentheses.

    jW
     
  3. Julien thread starter macrumors G3

    Julien

    Joined:
    Jun 30, 2007
    Location:
    Atlanta
    #3
    Tried entering absolute addresses but with the same results (and it auto changes back to relative (=Total Time for Month 'Apr 1, 2008'+Time 'Apr 2, 2008')). What is the syntax and how do I define the function and put the cell references in parentheses?
     

Share This Page