Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excell HELP!

### #1 LiaoGoren Posted 22 September 2007 - 03:20 PM

LiaoGoren

Member

• Member
• 261 posts
OK here is the deal, I am trying to track my income useing a spread sheet.

Now untill now I was paid by the mile and it was VERY simple to track. Just put in the miles and multiply it all out. I was getting within less that 1\$ from my actuall pay.

Now I am paid per hour. What I am doing now is annoying as all can get. I have to figure in my head or on paper the exact amount of hours and mins I worked. Then input that and let excell do the math. Its added an extra step.

What I wanna do is simply type in the time I clocked in, and type the time I clocked out and excell figures the total time I worked and does all the math.

I cant seem to find a formula to do that for me. I have tired many different combinations, with no luck.
I want to enter my time in one cell only, not 2 or more cells. So if there is anyone that has an idea, hit me with it and lets see if it works!
• 0

### #2 piper Posted 22 September 2007 - 06:21 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
Hi LiaoGoren.

Format the clock-in and clock-out cells as Custom (hh:mm). The cell that holds the calculation is formated as Number.

Here's the calculation:=((B2-A2)*24)*10

B2 = clock out
A2 = clolck in
*24 = converts time to decimal
*10 = plug in your hourly rate

This should work for you.
• 0

### #3 LiaoGoren Posted 22 September 2007 - 07:23 PM

LiaoGoren

Member

• Topic Starter
• Member
• 261 posts
THANKS!

ok That seems to work, but what do I do if I work past midnight?

I normally work 2pm-1030pm.

It does not seem to work when working past midnight ...lol

from what I can tell thats just something I am going to have to work around cause thats not just a number thing, thats a whole clock thing.

Any more suggestions?
• 0

### #4 piper Posted 22 September 2007 - 07:31 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
Of course I have more suggestions!!

Format the clock-in and clock-out cells as Time (1:30 PM). The calculation is now: =(((B2-A2)-INT(B2-A2))*24)*10

This works for me. I put 8:00 pm as clock in and 2:00 am as clock out, with 10 as the hourly rate. I got 60.00.
• 0

### #5 LiaoGoren Posted 22 September 2007 - 07:48 PM

LiaoGoren

Member

• Topic Starter
• Member
• 261 posts
Ok this is not seeming to let me give a detailed explanition of what Im looking for... cause I think I just need the conversion and im ok

I work mon-fri 2pm-1030pm
I dont clock out for lunch, but only get paid for 8 hours.
I also get paid for over time
I sometimes get 8 hours of holiday,vac, or sick pay with no lunch taken out... so heres my idea(this is just a condenced example )

a1=time in
a2=time out
a3=total time paid for( I need this formula where it figures for the 30min lunch, problem is when I dont work is shows as a neg number.... and cant find out how to stop that!)
a4=going to put an 8 if I get paid for day off cause this doesnt count for over time
Now there are 7 days a week so a-g look like that.
h1=total hours for week paid which could be more than 40 so I can figure overtime (this is easy for me!)
h2=total of holiday,sick,vac
h3=h1+h2*my pay = my total paycheck (gross)

If I can just get past the time and neg stuff I think I will be ok... lol

I think I just over explained a very very small easy fix.... lol thanks for your help!
• 0

### #6 piper Posted 22 September 2007 - 08:35 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
Okay. Take a look at the attached.

• 0

### #7 LiaoGoren Posted 22 September 2007 - 08:44 PM

LiaoGoren

Member

• Topic Starter
• Member
• 261 posts
That INT formula I dont understand how it works, but it seems to work wonders.... I think you just gave me the magic formula .... lol

THanks a TON!
• 0

### #8 piper Posted 22 September 2007 - 08:47 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users