welcome to the OzGrid forum!
If you attach a small example sheet, I will (try to) put in the formula needed.
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.
In time in A1 as 24 hr format
Out time in B1 as 24 hr format
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
Library Theatre Hours_Earnings.xls
Last edited by dzdoris; November 20th, 2006 at 22:39.
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.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)