Need Excel help.

Nevakonaza · 25 Oct 2012 at 17:04

Hey guys,

Right,Please don't laugh

.....never used Excel before but im looking to keep tabs on my working hours so i can check my wages to make sure they pay my overtime!

Now this is how im trying to do it.

When i auto sum C3+D3,Im trying to get excel to calculate my start-finish hour for that day so i know how many hours i done...but as you can see its saying i done 20 hours.

I know its something im not doing right,but looking online at tuts it shows you all these complex things you have to type...i thought you could get it to auto calculate for you?

Appreciate the help a lot!

Nevakonaza · 26 Oct 2012 at 03:49

shoot1st said:
Copy this into the cells from E3 to E9 ...

=IF(AND(C3<>0,D3<>0),IF(D3<C3,D3+1-C3,D3-C3),"")

Format the cells C3-E9 as hh.mm (right-click > format cells > Custom > hh.mm).

Tried what you said,All the totals come to 5:00

....obviously i done something wrong somewhere.

mranderson said:
Why would you autosum when you want the difference between two time points?

Like i said in my first post,Its the first time ive used Excel.

Nevakonaza · 26 Oct 2012 at 13:39

Anyone? :/

Nevakonaza · 26 Oct 2012 at 14:23

Im not getting this at all,done the above exactly and all i get is random numbers added up that makes no sense.

If i type for instance 6 & 2 in two of the boxes and auto sum it calculates it to 8 for me so its adding up,But i just cannot get this damn thing to calculate time!

Nevakonaza · 29 Oct 2012 at 09:44

Ethermaster said:
https://dl.dropbox.com/u/908850/Timesheet.xlsx

Just created this for you enjoy, hopfully its what you wanted.

This is more like it thanks!

Just tried it,As you guys can see its calculating how many hours i do each shift,but for some reason its not adding up the wage part right?

Left out the "Lunch Break" and "Overtime" as..

Lunch break is paid for within the shift,and overtime pay remains the same as what i normal earn if im doing a standard shift...we don't get paid any higher for doing overtime.

Thanks guys.

Nevakonaza · 29 Oct 2012 at 12:31

Perfect!

Thanks a lot Ethermaster,Greatly appreciated.

Nevakonaza · 29 Oct 2012 at 12:55

Yeah,The Tax & Nat Ins part did not bother me,Basically all i wanted is something that i could note down the hours ive worked,and total hours that week added up..
so the wage calculation was a bonus really just gives me a rough idea how much il pick up that week.

Thanks again dude.