Applications :: Changing Numbers To Hours?

Apr 15, 2010

When I format a cell as time (13:30), why does it go to 00:00 when i enter "2." I want it to go to 2:00, but the only way to do it is enter the colon myself... there must be a way to enter "2" and have the cell show "2:00."

I am trying to compare an estimated time to actual time. The problem is my estimate is 4-5 hours. How can I make 4-5 hours show up(in number format) in one cell... is that even possible or do I need to make two cells, one for min time and one for max time?

View 4 Replies


ADVERTISEMENT

Applications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers

Jul 17, 2010

I've been ripping my hair out trying to find the answer to this.

In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.

For example:

Column A - 1 - 5

Column B - (value in Column A * 5)

I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.

The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"

View 1 Replies View Related

Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?

Mar 24, 2009

See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.

like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.

View 3 Replies View Related

MacBook Pro :: After Upgrade To Lion, 2010 Battery Life Dropped From 8-9 Hours To 3-4 Hours?

Feb 19, 2012

after upgrade to lion, 2010 battery life dropped from 8-9 hours to 3-4 hours?

Info:
MacBook Pro (13-inch Mid 2010), Mac OS X (10.7.3)

View 1 Replies View Related

MacBook Pro :: Jumps From 4 Hours Of Battery Power To 2 Hours?

Jun 15, 2012

I recently purchased my Macbook and I noticed that the battery power is jumping at least an hour every time I check how much battery power it has left. I wanted to know if this was normal.

View 9 Replies View Related

MacBook Pro :: Change India Numbers To Arabic Numbers?

May 22, 2012

how to change india numbers to arabic numbers?

Info:
MacBook
Pro, Mac OS X (10.6.7)

View 3 Replies View Related

Applications :: Alternative To IDVD To Burn 3 Hours Movie?

Jan 31, 2010

I've searched and I still cannot find a free program that will let me burn a movie to a DVD. I used handbrake to bring the video file down to 4.5 GB. I'm trying to put it on a 4.7 GB disc and iDVD still won't let me because it says it is too big! I've been tinkering with iDVD and it's making me crazy. There must be a way to just burn it. I don't need a menu. Keep in mind that I want to be able to watch it on a dvd player (as opposed to just transferring the file). Just an FYI, the video file is 3 hours and 28 mins. It can be .mkv or .mp4 (through handbrake).

View 3 Replies View Related

Applications :: Finding ITunes Recommendations For Listening Stats - Hours

May 20, 2009

Keep track of hours of music listened to in say a continuous 2 week span. This can be synced through your ipod and within itunes itself. And give ratings related to how much hours of music you have listened to in the those 2 weeks. So if you've listened to I dunno 12 hours of music within that span, it'll keep track and give you a rating like: 'casual listener' or if you have totaled up 40 hours of music listening you're an 'avid music fan'. I dunno what to call them but I like knowing how much music I've really listened to recently and this would be cool.

Or to take it even further, see what genre (granted you have this organized in iTunes) that you're listening to most and this can go even deeper.

View 13 Replies View Related

Applications :: ITunes Downloading Time Jumping From Mins To Hours

Feb 9, 2010

I live in japan if it makes a difference, but download through US iTunes. Starting tonight, my subscribed tv shows are downloading extremely slow. the time is jumping around crazy from ETA 2 minutes to 203hours. Rented a movie on ATV and there was no lag. Not sure what is going on.

View 2 Replies View Related

Applications :: Finder Taking Hours To Delete IPhoto 105GB Data

Nov 9, 2009

With my new DSLR/RAW shots, I've bloated iPhoto to over 105GB for just over 20,000 photos. Was doing housecleaning, deleting files and the "aw *****" moment hit where I deleted some i wanted. Went into TimeMachine and did a Restore to my external 2TB HD (FW800) as temp place. Now, when I went to delete that 105GB file started last night 10:30 pm, here 7.5 hr later: still churning away.....wtf did I do wrong??

View 3 Replies View Related

Applications :: Getting A Percent In Numbers?

Mar 8, 2010

I'm having trouble get percentages in numbers. I want to get 5% of one cell and display the answer in another. Whats the formula for this.

View 4 Replies View Related

Applications :: Keep Blank Cell In Numbers?

Oct 4, 2010

The v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?

View 3 Replies View Related

Applications :: Creating Graphs In Numbers?

Oct 19, 2010

I just have a quick question about Numbers (iWork '09). I need to graph some supply and demand graphs for school. How would I go about doing this? Whenever I create a graph based on a chart, it just plots each row as it's own line. I can only edit the values in the Y-axis, and obviously I need to be able to work with the X-axis as well.

Update: I played around with it more and figured it out. I guess you have to graph it as a scatter plot and then choose to connect the dots, and remove the dots, rather than choose the line graph, whose icon looks just like a graph of supply and demand.

View 1 Replies View Related

Applications :: IWorks 08 - Numbers Freezing?

Jun 30, 2008

I'm a recent switcher from Excel to Numbers. For the life of me, I cannot find a way in Numbers to "freeze" headings so that as you scroll down or across the sheet they remain visible.

I'd be grateful for help; the matter is not covered in the video tutorials, nor in my little manual that came with iWorks, nor on the Help Menu.

View 21 Replies View Related

Applications :: Using Numbers For Accounts Receivable

Feb 13, 2009

I am using numbers for my accounts receivable. I have a formula which some dude created for me *years* ago that I used in Claris Works and it *seems* to work most of the time in Numbers. Anyway, the formula provides for either a debit or a credit and a balance. This is how it normally looks. However, for some weird reason the balance gets all screwed up whenever I enter cents into the equation. Check this out. I entered 5192 in the credit section and it changed the balance accordingly. However, when I add the 70 cents (.70) to the credit, the balance looks all messed up.

View 2 Replies View Related

Applications :: Unable To Use Numbers Formula

Mar 14, 2009

I'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.

View 5 Replies View Related

Applications :: Finding Mac Numbers Formula

May 27, 2009

I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically

View 2 Replies View Related

Applications :: Numbers - How To Rename Cells

Sep 26, 2009

In Excel, you can easily rename a cell to whatever you want. i.e from A1 to yaxis How do you do this in Numbers? I can't find it.

View 1 Replies View Related

Applications :: Saving As Excel In Numbers

Oct 28, 2009

I recently bought a Macbook Pro (and loving it) with iWork 09 pre-installed. I really like using numbers compared to office. However, I have just started working in a group where all the other members use Windows with Office 2007. I have been able to save my numbers (and pages) documents as the office equivalent. My problem lies when I am working on a document in numbers that is the office format. I like to continuously save my progress but whenever i press save, I have to save it as a whole new document or replace the existing one. When I used to work in office 2007 I used to just press save every now and then and it would save my changes. Am I doing something wrong or is it because I am working on an excel spreadsheet in numbers (word document in pages)?

View 3 Replies View Related

Applications :: Rounding Numbers In Excel?

Nov 28, 2009

A sheet of ply comes 1220mm wide and my staircase is 1200 wide. Therefore I get two out of one cut of ply. Used an 'if' function <1220 to divide by two as I get two out of one sheet if it's less than 1220.

Cell D11 calculates the amount of ply (as width measurement) needed by using an 'if' function, and E11 works it out as an actual sheet. The problem is it's showing 0.47 instead of rounding it to the nearest whole sheet (1), even if only 10mm is used I need to buy a whole sheet.

View 2 Replies View Related

Applications :: Mac Pages - Using Different Page Numbers

Jan 4, 2010

I just wanted to know how I could start the page numbers in header and footer on the third page of my document. The first page is the title page and the second page is the table of contents, and of course I wouldn't want the page numbers to be on those pages.

I have searched on the web and in help but couldn't find anything.

View 3 Replies View Related

Applications :: Using Excel Formula In Numbers

Feb 22, 2010

I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.

In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another.

I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.

View 2 Replies View Related

Applications :: Can Download More Templates For Numbers

May 10, 2010

I just got into using Numbers, it's awesome, the templates are great, but I'd like some alternative ones if possible. Especially comparison tables. I'm ok with using the same template for eternity, it would just look better if I didn't.

View 2 Replies View Related

OS X V10.7 Lion :: Applications With Serial Numbers From Old To New Mac

Jun 15, 2012

I just purchased a new Retina Display MBP as an upgrade to my old iMac.I have over 200 Applications taking up the bulk of my drive, many of which have serial numbers that I no longer even know of due to loss of original boxes, or what have you. I am trying to avoid copying all of my content over to the new MBP, I would much rather just move what I actually need to and try to keep it a little "cleaner". So my question is, with a Time Machine Backup of my iMac... Can I plug that into the MacBook Pro, launch Time Machine, and simply drag the last backup's Applications over? Will the ones with the serial numbers run?

Info:
iMac (21.5-inch Mid 2010), Mac OS X (10.7.3)

View 1 Replies View Related

Applications :: Break Column Into Two Columns In Numbers

Aug 24, 2010

I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:

Joe Blow
888-888-8888

View 3 Replies View Related

Applications :: Smart Column Splitting In Numbers

Sep 24, 2010

I have a .txt file that is quite long and I need to get some data off of it. The file is made up of a few thousand lines each with a format similar to: 1 2.4 5.4 abcde abc.def, The 1, the 2.4, the 5.4, etc each signify a different value and I need to somehow get them into separate columns into excel. The number of digits in everything except the first value (which is always one digit) varies, and all the values are separated by spaces. What is going to be the easiest way for me to get these values into numbers in separate columns? Realistically, doing this manually isn't an option.

View 2 Replies View Related

Applications :: Numbers - Formula For Scheduling A Timetable

Oct 14, 2010

I am studying, there is a weekly timetable made of 20 individual classes, each on 4 times a week. I would like to know how to make a spreadsheet so I can manually input all these classes and have it return a non conflicting pattern. By that I mean that I want a personal timetable that will let me visit each class at least once a week.

View 1 Replies View Related

Applications :: Can't Open Numbers Doc From Mobile Me On MacBook Air?

Oct 15, 2010

Got a weird problem. I store alot of documents on my iDisk so I can access them on either my MacBook Air or my iMac. It has worked great for several years.

I'm using Numbers '08 on both computers and both computers are completely updated.

Several weeks ago, the MacBook Air quit allowing me to open a Numbers document stored on Mobile Me. When I try to open a Numbers doc, I get a message saying, "The document could not be opened."

However, all is fine on my iMac. All numbers documents will open as normal from Mobile Me.

Also, other types of documents will open fine on the MacBook Air from Mobile Me i.e. Preview, Pages.

I tried copying a Numbers doc from Mobile Me to the Air, but I get an error stating, "The operation can be completed because and unexpected error occurred(error code -8084)."

Also, If I'm not dealing with Mobile Me, Numbers seems to work fine on the Air. I can create documents and open them fine.

In desperation, I did a clean install on the Air, but to no avail. I still have the same problem.

I can't think of anything I did to the Air to make it suddenly quit opening docs from Mobile Me.

View 2 Replies View Related

Applications :: Adding Drop - Down Menu In Numbers

Oct 20, 2010

I am attempting to modify the given template CHECKING ACCOUNT REGISTER in Numbers. I have figured everything out except how to modify the "Category" column where a drop-down menu is given for several recurring items (Home/Gas/Food/etc.) that are to be entered in that column. I would like to find how to create such a column or to be able to modify the one provided in the template. The TRANSACTIONS table is linked to the ACCOUNT CATEGORIES table which is linked to the CHART. That is intact and working as it should, but I have been unable to alter the column CATEGORY so that the drop down items will be ones that I want to use. Having the drop-down menu insures proper itemization in the linked ACCOUNT CATEGORIES table where typos are avoided as a result. The PDF manual was of little help (to me anyway) in addressing this seemingly simple alteration.

View 1 Replies View Related

Applications :: Merge Cells IWork 09 Numbers?

Oct 21, 2010

Is there a keyboard shortcut to merge selected cells?
Numbers '09, version 2.0.3 (332)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved