Results 1 to 4 of 4
  1. #1
    Excel vs. Numbers - Help please
    ekologik's Avatar
    Member Since
    Dec 03, 2007
    Location
    Canada
    Posts
    74
    Specs:
    MacBook 2.4 GHz Intel (unibody), 2 GB RAM; iPhone 3Gs
    Unhappy Excel vs. Numbers - Help please
    hi there, i'm a switcher trying to get numbers to do something i could do in excel.

    i keep track of my work record in a log in excel. in numbers, when i type in 0:15 for example, it automatically corrects it to 12:15 AM, but i don't want it to (because i want it to remain 0:15 as in 15 minutes so that i can use the autosum feature and add it all up). it never corrected this in excel.

    any idea to fix this so that it won't automatically correct this? i like auto-correction when it comes to dates and stuff but not in this situation.

    or if not, are there any templates or other ways i can keep track of a work log in numbers?

    if you can help please let me know. thanks.
    MacBook
    iPhone 3Gs

  2. #2
    Excel vs. Numbers - Help please
    fleurya's Avatar
    Member Since
    Nov 18, 2006
    Location
    Anytown, USA
    Posts
    4,925
    Specs:
    27" iMac 2.7GHz Core i5, iPhone 4S, 3rd gen iPad
    It's sounds like a simple auto cell format issue, and all you need to do is go change the cell format manually. If you use the same spreadsheet as a template all the time, you should only have to fix it once and never worry about it again.

    I'm curious though as to how you were able to sum such an entry in Excel. I just entered a few cells with 0:15 and tried to sum them, but excel wouldn't accept it.
    "Give so much time to the improvement of yourself that you have no time to criticize others"

  3. #3
    Excel vs. Numbers - Help please
    dtravis7's Avatar
    Member Since
    Jan 04, 2005
    Location
    Modesto, Ca.
    Posts
    28,477
    Specs:
    iMac late 2007 10.11.b4, iMac 2008 10.10.5, Macbook2007 10.7.5, Mac Mini 10.7.5, iPhone 3GS Note 8!!
    I tried pretty much everything and the only way I can get it to Sum the numbers correctly is put them as 0.15 instead of 0:15. Every time I use a colon no matter how I have the format set it shows nothing when I SUM.

  4. #4
    Excel vs. Numbers - Help please
    ekologik's Avatar
    Member Since
    Dec 03, 2007
    Location
    Canada
    Posts
    74
    Specs:
    MacBook 2.4 GHz Intel (unibody), 2 GB RAM; iPhone 3Gs
    Quote Originally Posted by fleurya View Post
    It's sounds like a simple auto cell format issue, and all you need to do is go change the cell format manually. If you use the same spreadsheet as a template all the time, you should only have to fix it once and never worry about it again.
    how do i do this?

    Quote Originally Posted by fleurya
    I'm curious though as to how you were able to sum such an entry in Excel. I just entered a few cells with 0:15 and tried to sum them, but excel wouldn't accept it.
    well, maybe it's the way i had the other values? not sure. the rest were time values.. like, i'd do 10:00-11:00, then in the next cell 1:00 and then task name in the next cell... and repeat under that line for the next task... and i highlighted all going down starting at 1:00, so like, all of the total time and what not, and then also selected an empty cell below them all. pressed autosum and it automatically added them up as a total time value. this is in excel.
    MacBook
    iPhone 3Gs

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. EXCEL lover - NUMBERS...ah...hate it!
    By Dublin RIP in forum Switcher Hangout
    Replies: 19
    Last Post: 01-22-2015, 02:20 PM
  2. excel numbers
    By liz.onishi in forum OS X - Operating System
    Replies: 7
    Last Post: 09-14-2013, 01:25 PM
  3. Page numbers in Excel for Mac
    By khowell in forum OS X - Apps and Games
    Replies: 2
    Last Post: 03-01-2013, 01:26 PM
  4. Excel to numbers
    By elvisharwen in forum Switcher Hangout
    Replies: 3
    Last Post: 04-20-2010, 05:55 PM
  5. Excel/Numbers question
    By brianwmay in forum OS X - Apps and Games
    Replies: 3
    Last Post: 04-12-2008, 04:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •