The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community
Geekfinder
UFie Gear
Advertise on UF
Forum Rules
& FAQ

Username

Password


Create a New Account

  
 

Back to UserFriendly Strip Comments Index
Spreadsheet help? OO.o Calc or Excel by hieraco 2007-07-29 09:20:55
I prefer Calc as that is what i'm using, but if you only have experience with Excel, it is probably close enough that I can use it.

I have a spreadsheet for recording my work hours. The rows are for each shift worked, and the columns are for Date, Start of shift, end of shift, Break, Lunch, Total hours, Pay hours (total minus lunch and break) Pay rate, Gross pay, Tax estimate (30% of Gross), and Net pay (After tax).

What I need to do is set up the Gross pay in such a way that it will calculate in the following manner:
IF DATE = Sunday then Gross Pay = pay hours x (1.5 x pay rate)
ELSE Gross Pay = pay hours x pay rate

I have it set to calculate pay on regular days as =PRODUCT(A3;H3) how would I set up this rule for Sunday shifts?

[ Reply ]
  have a look at the WEEKDAY() function by klep2007-07-29 09:37:39
    So then something similar to by sgrunt2007-07-29 09:42:44
      And use ';' instead of ',' in OOo calc. by kahuana2007-07-29 13:30:32
  Sorry, I can't think of a way. by RetiQlum22007-07-29 09:39:24
  drop me a line... by mekkanik_mike2007-07-29 11:19:56
  OY!!! by mekkanik_mike2007-07-29 12:03:55
  You get paid OT just because it's a Sunday? o.O (n/t) by kahuana2007-07-29 13:31:42

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)