Go Back   Sports Car Forum - MotorWorld.net > Hobbies and Leisure Time > Computers, Consoles, Gadgets And Gizmos



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 09-08-2005, 07:58 PM   #1
abbor
Regular User
 
Join Date: May 2004
Location: Trondheim, Norway
Posts: 1,068
Default Excel experts of the world, unite!

Okay, here's the situation...

At my work, we have this salary arrangement..

All days from Monday to Friday, I have 103,98 NOK before 18:00.
Between 18:00 and 21:00 I get 124,98 NOK.
Between 21:00 and 23:15 I get 144,99 NOK.

So I put together this Excel-doc to find out what I'm gonna earn:

http://home.no.net/redheadn/JW/Bok2.xls

The problem is that I'm not a very good programmer, this is the first time I ever used the IF-function in Excel.

I want to type in C and D when I have worked from and to, and then let Excel fill in the correct times under the different wages.

It works every time I fill in a time where I've worked within all the wages, but as soon there's one exception(See line 5), everything fucks up because of my code..

Can anyone please tell me what functions I should use instead of those I've used?
abbor is offline   Reply With Quote
 


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

Forum Jump