How brainy...

P_J · Nearly there... Joined: 24 Nov 2002 Karma :

ok, im playing around with this Excel Spreadsheet to try and work out how much im gonna get paid at work + over time etc.

I got most of this spreadsheet sorted except for the hours worked (sounds quite a large problem but not really, take a look). Enter the start time (24h clock), lunch, fin time and it should work out how many hours worked. This total ends up something like 7:30 (meaning 7.5 hours). using the spreadsheet 7:30 x hourly rate is not right, i need to automaticaly change 7:30 > 7.5! 7.5 X hourly rate works out.

This is to complicated to explain (i am a bit intoxicated), have a look, see if you can help out.
____________________
Dreams will get you nowhere, a good kick up the arse will take you a long way.
Only1PJ.co.uk

P_J · Nearly there... Joined: 24 Nov 2002 Karma :

erm, guess i better attach it eh.
____________________
Dreams will get you nowhere, a good kick up the arse will take you a long way.
Only1PJ.co.uk

P_J · Nearly there... Joined: 24 Nov 2002 Karma :

not one of the 50+ people that have looked at this know how to help? Surprised

guess ill just have to trust the stupid cow in our payments department to do her job right... theres always a first time for everything.
____________________
Dreams will get you nowhere, a good kick up the arse will take you a long way.
Only1PJ.co.uk

Ste · Not Work Safe Joined: 01 Sep 2002 Karma :

Quite what are you wanting us to do/ say? I've looked at it, and it's a timesheet spreadsheet. What is there to say?

TGE125NSR · Banned Joined: 07 Jul 2003 Karma :

Its just the way excel works.

Always cocks things up, if you go through all the settings across the top, you need to find one where you can change the format so you get the correct sum.

Something like moving the decimal point over either way so you get 7.5 each time instead of 7.30 or 7:30.

Weird thing, ill have a play in a bit see if i can suss it out!

Wink

TGE125NSR · Banned Joined: 07 Jul 2003 Karma :

hmmm

interesting. you know in the column where it says hours and underneath and down the column it says 7:30, is that a time you finish or something or is that the total amount of hours you worked in one day?

if you click on one of the cells where it says 7:30, and right click it and go down and choose format it gives you a list of options, when i did it the format is set as a custom time in hours and minutes. I presume you have done that?

So does that mean that you have set it like that but you dont want it displaying as 7:30? you want it as 7.5 ?

im kind of confused, but im slightly on track... ahem

Give us a bit more information and i maybe able to help you further.

P_J · Nearly there... Joined: 24 Nov 2002 Karma :

The 7:30 is the hours at work.

8:30 > 4:30, 30 mins for dinner is 7 and a half hours.

The sum will only work out correctly in hours and mins. so 7hours 30 mins

If you change the format to decimal, being 7.5, that would be great but it wont do it automaticaly. if you times 7:30 x hourly rate it gives you something like £0.70p if you times 7.5 x hourly rate, that works.
____________________
Dreams will get you nowhere, a good kick up the arse will take you a long way.
Only1PJ.co.uk

TGE125NSR · Banned Joined: 07 Jul 2003 Karma :

okay mate

i got you, ill have a play in a bit and see what i can work out.

cheers