Need Excel to Numbers formula help (pic)

[Julien]

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?

 

[Mal]

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

 

[Julien]

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

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?