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:
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:
It helped me. Thanks. It is surprising that the duration calcs aren't listed with the Time calcs in the iWork help files.
Thanks, It helped me too. Appreciated.
Post a Comment