RE: Excel Formula (Full Version)

All Forums >> [Casual Banter] >> Off the Grid



Message

happypervert -> RE: Excel Formula (8/17/2006 5:03:03 PM)

quote:

In computer speak ( ( B-A) /A ) does not equal B/A -A/A

I don't know what computer you are speaking to, but this is grade school level arithmatic and those statements ARE equal. Parsing by a program or compiler is irrelevant. But since you are the one who claims they aren't equal, then give us an example to support your claim.

I'm equally surprised you  were so bold you decided to impress us with your "solution" after LA said the ones posted earlier worked too, and then make the claim that basic mathematical identities are wrong. But I do appreciate the comedy of seeing you act all smug like you have provided the only correct answer when EVERY other solution posted above was also correct. I was just having fun with the math showing the equivalence, so it cracks me up to get a rebuttal. But thanks because it has been good for a "larf".

By the way -- you also talked about declaring variables as real integers and stuff like that. This isn't FORTRAN or whatever programming language you are referring to. In the modern world there are these devices called Personal Computers, and they have these nifty little programs called spreadsheets, and Excel is a brand of spreadsheet. That's what everyone else here is talking about. You should check it out sometime.



Daddy4UdderSlut -> RE: Excel Formula (8/17/2006 5:04:55 PM)

I don't program in Excel (use other languages)... but I think that if you Google something like: excel date time arithmetic, you should find out how to do date & time arithmetic in Excel-speak.



gooddogbenji -> RE: Excel Formula (8/17/2006 5:22:44 PM)

quote:

ORIGINAL: Daddy4UdderSlut

I don't program in Excel (use other languages)... but I think that if you Google something like: excel date time arithmetic, you should find out how to do date & time arithmetic in Excel-speak.



Dammit!  And I'm always the first to Google anything!

Yours,


benji



happypervert -> RE: Excel Formula (8/17/2006 5:23:08 PM)

quote:

One thing I did try was doing an If then thing - if b<a, use a different formula, namely a-b(giving me the number of hours they didn't work)-24, but it won't even recognize the "24."

have you tried working with the time conversion functions (Hour(), Minute(), etc)? I bet you use those you can get the other logic to work and even figure out how to subtract 24. I'm sure you can make it work, and then convert back to time format when you're done.



walkingsosoftly -> RE: Excel Formula (8/17/2006 7:05:13 PM)

want to do my staff timesheets on Excel.

Going from memory here so can only half answer and not 100% on the formulas to add time together. But to get the times to add up you need to;
1) In the 'Start' put date and time eg 08/09/2006 19:30
2) In the 'End' put date and time eg 08/10/2006 01:30 (note assumeing you are in MM/DD/YYYY format)
3) For 'total hours'. Do your formulas as if you were just doing time (I add each part of the 'split' seperatly- in different coloms then add the two together, but that was because formulas don't like me, more that it can't be done in the one cell)
4) Now the hard part- there is a formula that excel will add time to units eg 6hrs to $15.23, but I can't rember it (sorry). It is hidden in excel's not very helpfull "help" area though. (Shh- I gave up and just manualy typed them in, but we had different rates for different times/days and had to do manual splits-refused to go and do a 14 string 'what if', and had it caculate $$ from there)

Have I confused you more? [&:]



LuckyAlbatross -> RE: Excel Formula (8/17/2006 7:36:46 PM)

Wow I'm so glad my dorky little formula question could actually go to help other people save good time!

I'm surprised Excel doesn't put out a nifty package that has "If you want to do timesheets" template.

But then this is MS.

Good luck!  It's certainly beyond my skill. 



seeksfemslave -> RE: Excel Formula (8/18/2006 1:41:06 AM)

"happy" perv ....I admit that my heavy handed sarcasm indicated that I thought your solution was incorrect.

In this I was WRONG but what I said was technically correct. If you could see the machine code for the expression then you would see that the computor would handle it as I described.

Note (1)  On the face of it your solution seems more elegant but in fact the call to the % function makes it less so.

Note(2)  If you have never had errors in a computor programme due to arithemetic precedence problems then you are a better man than I am Gunga Din.







Page: <<   < prev  1 [2]

Valid CSS!




Collarchat.com © 2025
Terms of Service Privacy Policy Spam Policy
0.015625