Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6824
  • Last Modified:

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?
0
bd_good
Asked:
bd_good
  • 8
  • 3
  • 2
  • +1
1 Solution
 
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
 
bd_goodAuthor Commented:
Numbers is Apple's asnwer to Excel (currently) it is part of the iWork suite
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 8
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now