New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Excel vs. Numbers - Help please


Post Reply New Thread Subscribe

 
Thread Tools
ekologik

 
ekologik's Avatar
 
Member Since: Dec 03, 2007
Location: Canada
Posts: 74
ekologik is on a distinguished road
Mac Specs: MacBook 2.4 GHz Intel (unibody), 2 GB RAM; iPhone 3Gs

ekologik is offline
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
QUOTE Thanks
fleurya

 
fleurya's Avatar
 
Member Since: Nov 18, 2006
Location: Anytown, USA
Posts: 4,922
fleurya is a name known to allfleurya is a name known to allfleurya is a name known to allfleurya is a name known to allfleurya is a name known to allfleurya is a name known to allfleurya is a name known to all
Mac Specs: 27" iMac 2.7GHz Core i5, iPhone 4S, 3rd gen iPad

fleurya is offline
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"
QUOTE Thanks
dtravis7

 
dtravis7's Avatar
 
Member Since: Jan 04, 2005
Location: Modesto, Ca.
Posts: 27,846
dtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond reputedtravis7 has a reputation beyond repute
Mac Specs: iMac 2.4 C2D 10.10.1, iMac 2.16 C2d 10.6.8, Macbook2007 10.8.4, Mac Mini 10.8.4, iPhone 3GS Note 8!!

dtravis7 is offline
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.
QUOTE Thanks
ekologik

 
ekologik's Avatar
 
Member Since: Dec 03, 2007
Location: Canada
Posts: 74
ekologik is on a distinguished road
Mac Specs: MacBook 2.4 GHz Intel (unibody), 2 GB RAM; iPhone 3Gs

ekologik is offline
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
QUOTE Thanks

Post Reply New Thread Subscribe


« Diablo II | SW to send alert when specific decibel level reached? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Switcher - Excel & Word for Mac? mab OS X - Apps and Games 17 03-04-2008 11:05 AM
did work on numbers, pc friend cannot view with excel tacsniper OS X - Apps and Games 3 12-29-2007 08:50 PM
Issues w/ printing in Microsoft Excel for MAC! AAAAARGH MacNewbie OS X - Apps and Games 1 02-01-2007 03:51 AM
Inputting foreign characters into Excel - ?? rickhess Running Windows (or anything else) on your Mac 0 04-26-2006 11:47 AM

All times are GMT -4. The time now is 09:53 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?