iWork, Numbers add and subtract time ?

I keep statistics for and Ambulance service . We post departure and arrvl  times and then the elapsed time enroute.
In excel, one could use the formula (=(a3-a1))  and get answer expressed in minutes provided the cells referenced in the formula were formatted as time (military). It was fairly automatic in Excel, but Numbers won't seem to do it at all. There are 25 different formulas listed for time expressions but none expresslyfor this.
Also, two other funtions we used a lot in Excel were "fill down" command to paste the same formula in an entire column or row with corresponding cell relationships retained down the column.
and: 'Freeze heading'  to keep row and column titles visible while scrolling through a large worksheet and visually keep your place. Can't find thoset either, must be a particular search term for it in Apple speak?
bd_goodAsked:
Who is Participating?
 
byundtCommented:
In Numbers 2008, I did the following:
In cells A3 and A1 entered: 4:02 PM and 3:53 PM    (the same trick works with military times, too)
In cell A4, I entered the formula:
=1440*(A3-A1)

The result was 9, the number of minutes difference between the two times.

Like Excel, Numbers is storing a time as a date/time serial number, with 24 hours being equivalent to 1.0. To get minutes, you multiply by 1440, which is 24*60.

Brad
0
 
Saurabh Singh TeotiaCommented:
Can you please upload your sample file so that i can see whats wrong..since the formula which you said should work for you...
0
 
patrickabCommented:
Excuse me for asking but what is 'Numbers'?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bd_goodAuthor Commented:
Numbers is Apple's asnwer to Excel (currently) it is part of the iWork suite
0
 
bd_goodAuthor Commented:
In response to suarabh726: a sample of our date spreadsheet ( in Apple's Numbers) is attached.

please note I have tried all the methods that work in Excel with no result .
please not also that the file carries an ext of zip which is noted as "allowed" but this website just rejected it..what do I do (rename it ??)
Base file is (.numbers) that is the apple program that we are discussing sooooooooo ???

bd_good
0
 
Saurabh Singh TeotiaCommented:
I dont see your workbook..can you please upload it...
0
 
bd_goodAuthor Commented:
OK I tried a workaround here and renamed the file .xls ONLY attach and transmit it
 
it does not accept file any advice ??
 
bd_good
0
 
bd_goodAuthor Commented:
To: saurabh726

if you have an email address I might be able to send it you that way...but if you do not have a

copy of Apple's Numbers it won't work anyway
 
bd_good
0
 
bd_goodAuthor Commented:
to byundt:

Yeah that appears to work. ...I thank you  
0
 
bd_goodAuthor Commented:
to byundt:

That should have read: YAY !!!
 
bd.good
0
 
bd_goodAuthor Commented:
Is there a variant of this that would work for longer time intervals (where the answer would be 'hours)?
0
 
byundtCommented:
bd.good,
To get hours (and decimal fractions of hours) you would multiply by 24.
=24*(A3-A1)

Thanks for the grade!
Brad
0
 
byundtCommented:
bd_good,
I see that you have asked a new question regarding the "Freeze Panes" feature. I looked for it unsuccessfully in Numbers and suspect that it may not exist in the 2008 version. I don't have a copy of 2009 iWork suite, and so couldn't check there.

I'll be monitoring your new question in case somebody else knows--that way we'll both learn.

Brad
0
 
bd_goodAuthor Commented:
Tks again Brad!!
I only have iWork 08 so you weren't wrong there and I don't feel so stupid.

geo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.