Adding up if over/less than a time

  • Thread starter Thread starter JamieLee2k
  • Start date Start date
J

JamieLee2k

I am really new to excel and starting to love it, but I have come stuc
and would really like some guidence.
I have made this sheet for work where it keeps track of all of ou
hours worked and the basic idea is you put in the time started an
finished and at the end of the week it will add up how many hours yo
have worked and after that, if the figure add's upto more/less than th
time speicfied then it will say owed/owing and the amount.

I have asked on other places and nothing has caught my eye appart fro
this one guy but it's causing me some problems and I don't like how h
has done it do if someone can look at this please and if they can help
that would be great

'Here is the sheet I made' (http://www.jlrforum.net/jlr/New Late
Extended Hours Sheet.xls)

Where it's got Hours owed/owing that was where I wanted to add th
cells and if that doesn't add upto 47:30 week then it needs to sa
either, example you worked 2 hours less then it would say -2:00 or i
you worked 2 hours more it would say 2:00. it's upto you how you do i
but I am really stuck here and I can't believe it's so hard to do.

Now all of us (4 ppl in the sheet) work 5 days a week and so it's onl
over 5 days, I have tried to colour the writing if you do overtime s
you should know the difference
 
BTW If anyone has any sheets they made so I can get an idea of how the
did it cus I want to learn a bit more about it,
Thanks
Jami
 
Hi
as a starting point:
http://www.cpearson.com/excel/overtime.htm
-----Originalnachricht-----
I am really new to excel and starting to love it, but I have come stuck
and would really like some guidence.
I have made this sheet for work where it keeps track of all of our
hours worked and the basic idea is you put in the time started and
finished and at the end of the week it will add up how many hours you
have worked and after that, if the figure add's upto more/less than the
time speicfied then it will say owed/owing and the amount.

I have asked on other places and nothing has caught my eye appart from
this one guy but it's causing me some problems and I don't like how he
has done it do if someone can look at this please and if they can help,
that would be great

'Here is the sheet I made'
Click to expand...
(http://www.jlrforum.net/jlr/New Lates
 
Now I understand that better and getting it to add overtime is fine bu
what about getting it under the aloted time
 
Back
Top