Sponsored By

Sign in to follow this  
mikex

Ovetime Excel Spreedsheet

Recommended Posts

I am trying to use this link to make a two week timesheet.

I am in Ubuntu so I have Open Office calc, but it should still work.I need in(morning) out(lunch) in (from lunch) out (end of day) reg hours and overtime hours.

Reg and OT hours calculated for each week.

I am attaching what I have. Let me know where I went wrong.

M

Can't upload .xls files sorry.

M

Working from my backup machine...Thanks Shanenin

In cells H 16 and I 16 I have info for reg time and OT rate. It is in white, to hide it. Just didn't want it to show when printed.

M

Edited by mikex

Share this post


Link to post
Share on other sites

you could use the linux command 'zip', to zip your file, then upload it

zip time.zip time.xls

Edited by shanenin

Share this post


Link to post
Share on other sites

hi Mike,

got it figured out and set up for you.

in the webpage where you were getting your guidelines they used the comma , in the formula, for OOo you need to use the semi-colon ; then everything worked.

I also did a little hidden number sequence to get the formula working properly. if you look at the worksheet the numbers are "invisible" but they are actually there only in teh White font color. The entries are as follows:

H15 is the actual payrate per hour, for example say you make $10.00/hr, in H15 I would have the 10.00

H16 is the number that is the general basis for regular hours, 8

I16 has the multiplier for the overtime rate of 1.5

One thing I noticed when I was working with this, in your clock in clock out sections, you don't have the proper formatting for time, If you click on any of the entries for clock in/clock out you will see what i mean compared to the first entry in the list.

timeweek11.zip

Share this post


Link to post
Share on other sites

Dragon,

Thanks.

I have since reinstalled XP and Office.

It is easier to work with here at work.

M

Share this post


Link to post
Share on other sites

ya know you can use OOo in Windows XP also right?

If I had caught this when you first posted it I would have gotten it done the same day. sorry for the delay on that.

Share this post


Link to post
Share on other sites

Not a problem. Thanks for your help. Tweaked it some more for what i wanted. I like excel over OO calc. dunno maybe nothing but just like excel more.

M

Share this post


Link to post
Share on other sites

when you're used to one program it's hard to "convert" to a similar one that uses different syntaxes.

glad I could help though.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this