February 14, 2011

Tips&Tricks: iWork Numbers - difference in minutes between two dates

I can work with relative ease with Excel and OpenOffice Spreadsheet but the iWork Numbers application was totally new for me. I was working on a report in Numbers and I didn't know how to calculate the difference in minutes between two date fields and, I must say, that I didn't find the information I needed fast enough on the web.

To keep the long story short, after 2-3 minutes of trial and error, I came across the answer: the formula I was looking for was:

DUR2MINUTES(Field1-Field2)

Hope this saves someone a bit of time.

2 comments:

Anonymous said...

It helped me. Thanks. It is surprising that the duration calcs aren't listed with the Time calcs in the iWork help files.

Anonymous said...

Thanks, It helped me too. Appreciated.