ASP Free Lounge
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > ASP Free Lounge
Reload this Page

General Question - Newbie Needs Excel Formula help

Discuss Newbie Needs Excel Formula help in the ASP Free Lounge forum on ASP Free.
Newbie Needs Excel Formula help ASP development forum discussing anything that doesn't fit into the other forums. This is the place to relax, talk, and maybe even have some friendly debate.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old October 31st, 2007, 09:43 PM
Carl_M Carl_M is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 3 Carl_M User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 22 sec
Reputation Power: 0
Question General Question - Newbie Needs Excel Formula help
I want to add three cells and another three cells, then subtract one result from the other.

The data is time in hh:mm format. They are start and stop times. Some of the cells may not have entered data i.e. only one or two start/stop value of three possible. If there is a start there will always be a stop.

The sums' may (will) total >24:00 and the final result may = 24:00 but never more than 24:00

I have tried =IMSUB("=SUM D3,F3,H3","=SUM C3,E3,G3") without success.

Please show me what I did wrong.

Thank you in advance.
Carl
Reply With Quote
  #2  
Old October 31st, 2007, 09:58 PM
lewy's Avatar
lewy lewy is offline
Alter Ego Wizard
ASP Free Specialist (4000 - 4499 posts)
  
Join Date: Jun 2004
Location: Edinburg Tx
Posts: 4,385 lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 1009 Folding Title: Novice Folder
Time spent in forums: 1 Month 1 Week 2 Days 52 m 30 sec
Reputation Power: 1561
Welcome to the forums

Have you tried:
Code:
=(D3+F3+H3)-(C3+E3+G3)
__________________
................... ASCII and ye shall receive ..................
Knowledge is the only resource on earth that multiplies when shared

Support the Shemzilla Project
Powered by C#
Reply With Quote
  #3  
Old October 31st, 2007, 10:51 PM
Carl_M Carl_M is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 3 Carl_M User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 22 sec
Reputation Power: 0
That was too easy! Thank you much.

What was wrong (other than too complicated) with what I tried?

Carl
Reply With Quote
  #4  
Old November 1st, 2007, 03:34 PM
Lauramc's Avatar
Lauramc Lauramc is offline
SQL Slarentice
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Nov 2004
Location: In My Happy Place
Posts: 1,814 Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level)Lauramc User rank is General 3rd Grade (Above 100000 Reputation Level) 
Time spent in forums: 2 Weeks 1 Day 21 h 1 m 49 sec
Reputation Power: 1143
Quote:
Originally Posted by Carl_M
That was too easy! Thank you much.

What was wrong (other than too complicated) with what I tried?

Carl
Well, you can't use equals "=" except as the beginning of the formula. Also any use of a formula requires parentheses () and when summing or separating any parameters you need to separate each cell listed with a comma.

Using your original example, you would do this:
Code:
=IMSUB(SUM(D3, F3, H3), SUM(C3, E3, G3))
I have never used IMSUB though, so I am not sure what the use of it is. Let me know what kind of results you get with it.

I hope this helps!

Edit: Testing of IMSUB seems to indicate that it subtracts the two numbers passed into it. In this case it would be the result of the two SUM operations.
__________________
Slarentice (origin:Shadow Wizard of ASP Free) [noun] A slave and apprentice of the Wizard's Circle (specifically of mehere) at ASP Free.
----
If shemzilla takes over, it's best to be on his good side

Last edited by Lauramc : November 1st, 2007 at 03:39 PM.
Reply With Quote
  #5  
Old November 1st, 2007, 03:34 PM
lewy's Avatar
lewy lewy is offline
Alter Ego Wizard
ASP Free Specialist (4000 - 4499 posts)
  
Join Date: Jun 2004
Location: Edinburg Tx
Posts: 4,385 lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)lewy User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 1009 Folding Title: Novice Folder
Time spent in forums: 1 Month 1 Week 2 Days 52 m 30 sec
Reputation Power: 1561
You were using a complicated function that was not really designed to do simple addition and subtraction.

More Information about IMSUB

Glad I could help
Comments on this post
Lauramc agrees: Wish I could rep ya. I was looking at the syntax lol!
Reply With Quote
  #6  
Old November 1st, 2007, 05:17 PM
Carl_M Carl_M is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Oct 2007
Posts: 3 Carl_M User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 22 sec
Reputation Power: 0
Cool
I used this example and it returns a decimal, rather than the total time. The IMSUB is not useful for this.

Thank you for your fix

Carl







Quote:
Originally Posted by Lauramc
Well, you can't use equals "=" except as the beginning of the formula. Also any use of a formula requires parentheses () and when summing or separating any parameters you need to separate each cell listed with a comma.

Using your original example, you would do this:
Code:
=IMSUB(SUM(D3, F3, H3), SUM(C3, E3, G3))
I have never used IMSUB though, so I am not sure what the use of it is. Let me know what kind of results you get with it.

I hope this helps!

Edit: Testing of IMSUB seems to indicate that it subtracts the two numbers passed into it. In this case it would be the result of the two SUM operations.
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > ASP Free Lounge > General Question - Newbie Needs Excel Formula help

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway. 
Stay green...Green IT