RE: Excel Formula

Collarspace Discussion Forums

Home Login Search

RE: Excel Formula

View related threads: (in this forum | in all forums)

Logged in as: Guest

All Forums >> [Casual Banter] >> Off the Grid >> RE: Excel Formula

Page: << < prev 1 [2]

Message

<< Older Topic Newer Topic >>

RE: Excel Formula - 8/17/2006 5:03:03 PM

happypervert

Posts: 2203
Joined: 5/11/2004
From: Scranton, PA
Status: offline

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.

(in reply to seeksfemslave)

Profile

Post #: 21

RE: Excel Formula - 8/17/2006 5:04:55 PM

Daddy4UdderSlut

Posts: 240
Joined: 4/2/2005
Status: offline

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.

(in reply to gooddogbenji)

Profile

Post #: 22

RE: Excel Formula - 8/17/2006 5:22:44 PM

gooddogbenji

Posts: 5094
Joined: 11/15/2005
From: Toronto
Status: offline

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

_____________________________

Prevent global warming. Stop burning patchouli.

(in reply to Daddy4UdderSlut)

Profile

Post #: 23

RE: Excel Formula - 8/17/2006 5:23:08 PM

happypervert

Posts: 2203
Joined: 5/11/2004
From: Scranton, PA
Status: offline

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.

(in reply to gooddogbenji)

Profile

Post #: 24

RE: Excel Formula - 8/17/2006 7:05:13 PM

walkingsosoftly

Posts: 1
Joined: 6/18/2006
Status: offline

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?

(in reply to gooddogbenji)

Profile

Post #: 25

RE: Excel Formula - 8/17/2006 7:36:46 PM

LuckyAlbatross

Posts: 19224
Joined: 10/25/2005
Status: offline

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.

_____________________________

Find stable partners, not a stable of partners.

"Sometimes my whore logic gets all fuzzy"- Californication

(in reply to walkingsosoftly)

Profile

Post #: 26

RE: Excel Formula - 8/18/2006 1:41:06 AM

seeksfemslave

Posts: 4011
Joined: 6/16/2006
Status: offline

"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.

(in reply to LuckyAlbatross)

Profile

Post #: 27