 |
 |
Need help with a Numbers formula
|
|
|
|
|
Professional Poster
Join Date: Sep 2000
Location: Carbondale, IL
Status:
Offline
|
|
I need a formula that will calculate the time it took from point A to point B
Example.
If i put in 07:15 in one cell...and 13:10 in another cell, I need a formula that will calculate it took 5 hours and 55 minutes to go from A to B.
any help?
|
|
AIM: bmichel5581
MacBook 2.2 GHz Intel Core 2 Duo
4GB RAM
160GB
|
| |
|
|
|
|
|
|
|
Posting Junkie
Join Date: Oct 2005
Location: Houston, TX
Status:
Offline
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
Professional Poster
Join Date: Sep 2000
Location: Carbondale, IL
Status:
Offline
|
|
did you ever try to see if that worked? Don't you think i woulda thought of something that simple...
Seriously.
|
|
AIM: bmichel5581
MacBook 2.2 GHz Intel Core 2 Duo
4GB RAM
160GB
|
| |
|
|
|
|
|
|
|
Posting Junkie
Join Date: Oct 2005
Location: Houston, TX
Status:
Offline
|
|
Sorry, I didn't read the title and assumed Excel since that's what most people use. Numbers is completely braindead (and slower than dog poop with large tables).
Good luck!
|
|
|
| |
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Jul 2007
Status:
Offline
|
|
I don't have Numbers, but I tried the following in NeoOffice Calc and got the correct answer: In cell a2 I put 07:15, in b2 I put 13:10, then in c2 I entered =(b2<a2)+b2-a2. 05:55 was computed. You might give that a try in Numbers.
|
|
|
| |
|
|
|
|
|
|
|
Professional Poster
Join Date: Sep 2000
Location: Carbondale, IL
Status:
Offline
|
|
Originally Posted by mduell 
Sorry, I didn't read the title and assumed Excel since that's what most people use. Numbers is completely braindead (and slower than dog poop with large tables).
Good luck!
Yeah, you're right....it does work in Excel.....
kinda disappointed that I can't get it to work in Numbers 
|
|
AIM: bmichel5581
MacBook 2.2 GHz Intel Core 2 Duo
4GB RAM
160GB
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Jul 2003
Location: Washington state
Status:
Offline
|
|
It works just fine in Numbers except that it returns the decimal portion of a day 0.2465....
Multiplied out, it gives the right answer!
sam
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
Top