bd_good
asked on
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?
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?
Saurabh Singh Teotia
Can you please upload your sample file so that i can see whats wrong..since the formula which you said should work for you...
Excuse me for asking but what is 'Numbers'?
ASKER
Numbers is Apple's asnwer to Excel (currently) it is part of the iWork suite
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
I dont see your workbook..can you please upload it...
ASKER
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
it does not accept file any advice ??
bd_good
ASKER
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
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
ASKER
to byundt:
Yeah that appears to work. ...I thank you
Yeah that appears to work. ...I thank you
ASKER
to byundt:
That should have read: YAY !!!
bd.good
That should have read: YAY !!!
bd.good
ASKER
Is there a variant of this that would work for longer time intervals (where the answer would be 'hours)?
bd.good,
To get hours (and decimal fractions of hours) you would multiply by 24.
=24*(A3-A1)
Thanks for the grade!
Brad
To get hours (and decimal fractions of hours) you would multiply by 24.
=24*(A3-A1)
Thanks for the grade!
Brad
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
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
ASKER
Tks again Brad!!
I only have iWork 08 so you weren't wrong there and I don't feel so stupid.
geo
I only have iWork 08 so you weren't wrong there and I don't feel so stupid.
geo