Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: calculate earnings from time worked x hourly rate

1. I agreed to these rules
Join Date
18th April 2006
Posts
1

## calculate earnings from time worked x hourly rate

I am trying to calculate earnings based upon hours worked based on 24 hours format (time out - time in = time worked) multiplied by hourly rate. I cannot get the proper calculation. How can I attach a copy of the Excel worksheet?
Last edited by hduff; April 18th, 2006 at 06:57.

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: calculate earnings from time worked x hourly rate

Hi Hduff,

welcome to the OzGrid forum!

If you attach a small example sheet, I will (try to) put in the formula needed.

Wigi

Excel Video Tutorials / Excel Dashboards Reports

3. Senior Member
Join Date
27th January 2003
Location
Montana
Posts
204

## Re: calculate earnings from time worked x hourly rate

In time in A1 as 24 hr format
Out time in B1 as 24 hr format

=(B1-A1)*24*HourlyRate

lenze

Excel Video Tutorials / Excel Dashboards Reports

4. ## Re: calculate earnings from time worked x hourly rate

See if this is what you are after.

Excel Video Tutorials / Excel Dashboards Reports

5. I agreed to these rules
Join Date
20th November 2006
Posts
3

## Re: calculate earnings from time worked x hourly rate

Hi Guys

This is my first post so please be gentle (hope I've posted in the right place!)

I'm trying to work out a spreadsheet for my earnings from one of my jobs. I got some great info from the above post but what I'm struggling on now is how to overcome the "working till midnight" issue. My spreadsheet calculates that if I've worked from 17:00 to 00:00 I've worked minus 17 hours? How can I overcome this?

I've attached my spreadsheet for you to dissect : D

Nikki

Library Theatre Hours_Earnings.xls
Last edited by dzdoris; November 20th, 2006 at 23:39.

Excel Video Tutorials / Excel Dashboards Reports

6. Senior Member
Join Date
3rd October 2006
Location
Cardiff, UK
Posts
263

## Re: calculate earnings from time worked x hourly rate

Well, the simplest way would be to put in 24:00 instead of 00:00 (it is, after all, a 24hr clock). It then shows as 7hrs.

HTH

KJ

Excel Video Tutorials / Excel Dashboards Reports

7. I agreed to these rules
Join Date
20th November 2006
Posts
3

## Re: calculate earnings from time worked x hourly rate

Awww thanks KJ - why didn't I think of that???

Nikki

P.S. Great site, only just come across it! Could have done with this years ago!!

Excel Video Tutorials / Excel Dashboards Reports

8. Senior Member
Join Date
3rd October 2006
Location
Cardiff, UK
Posts
263

## Re: calculate earnings from time worked x hourly rate

No problem.

The amount of times i've wracked my brain for hours trying to solve problems in a convoluted way only to post here and a helpful soul bring me back to earth with a simple solution.

This forum is a life-saver.

KJ

Excel Video Tutorials / Excel Dashboards Reports

9. Super Moderator
Join Date
7th December 2005
Location
Hampshire, England
Posts
4,898

## Re: calculate earnings from time worked x hourly rate

dzdoris, Glad you got what you wanted, but we have a rule on here that you must not hijack a post - you start your own. (You did read the rules did you?)

Excel Video Tutorials / Excel Dashboards Reports

10. I agreed to these rules
Join Date
20th November 2006
Posts
3

## Re: calculate earnings from time worked x hourly rate

So sorry

I did sort of whizz through them and then after I posted read them properly, realised my mistake and PM'd Dave Hawley to apologise

It just seems that this forum does exactly what all the others ask you not to i.e. start a post when there's already one for what you're asking??

I've learnt from my mistake and promise it won't happen again!

Nikki

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno