Having trouble making a basic time sheet to track my hours

Its probably really easy to do but for whatever reason my mind is drawing a blank. I am trying to make a basic time sheet that shows the hours I have worked and the amount the company owes me as a double check against the companies punch in system. I think its an issue with my formatting but can not seem to find the right formatting to make the numbers come out right. Also seem to run into an issue with excel when I use midnight as an end point for a shift. I have attached a sample of my spreadsheet on what I have so far. Any help in this is greatly appreciated. Also if you could show me a better way of doing it that would be awesome too as I am pretty sure my method is highly overly cumbersome. See below for sheet explanation:

I have nine columns so far:
a)Date (day and date of month I clocked in date format)
b)Start Time (start of work day in time format (1:30 pm)
c)End Time (time I clocked out in time format (1:30 pm))
D)Hours (total hours at company in hh:mm format would like decimal format)
E)Lunch (length of lunch break in decimal of an hour)
F)Real Hours (total hours at company - lunch break time in decimal form)
G)Rate (my hourly rate in currency format)
H)Earned (amount earned for that day)
I:Bonus column figuring bonus amount to be shown on pay stub (have not figured out what to do with this column yet)

Usual rate is $8.00/hour unless its Friday, Saturday, or Sunday then I get paid $9.00/hour but the extra $1.00 shows up as bonus pay on the pay stub. I am allowed 30 minutes for lunch but this is unpaid time.

Originally Posted by Ace_XL

See if the attached helps

=--(C2<B2)+C2-B2

You do not need put "--" when you do arithmetic. Your formula can be shorten up to this


=(C2<B2)+C2-B2