Creating Formulas for timesheets

[Numbers Grrl]

Hi!
I am trying to create a timesheet with formulas to count 3 things. Total hours worked, regular hours worked (any hours up to 8) and overtime hours (over 8 hours).
I am having trouble with the formula for counting anything between 0-8 hours from my total hours worked. Can someone help me please?

Clock in 8:00am
Clock out Lunch 12:30PM
Clock in Lunch 1:00PM
Clock out 5:00pm

Total hours 8:30
Regular hours 8:00
Overtime hours .30

After I have the hours can you help me with a formula to convert the hours into decimals?

 

[6StringJazzer]

This shows the calculations for time values, and also for decimal hours.

$scratch.xlsm
	A	B	C
1	Clock in	8:00 AM	8:00 AM
2	clock out lunch	12:30 PM	12:30 PM
3	Clock in lunch	1:00 PM	1:00 PM
4	Clock out	5:00 PM	5:00 PM
5
6		Using time format	Same thing in decimal
7	Total Hours	8:30	8.5
8	Regular Hours	8:00	8.0
9	Overtime hours	0:30	0.5
Time Sheet

Cell Formulas
Range	Formula
B7	B7	=B$2-B$1+B$4-B$3
C7	C7	=(C$2-C$1+C$4-C$3)*24
B8	B8	=MIN(TIMEVALUE("8:00"),B7)
C8	C8	=MIN(8,C7)
B9:C9	B9	=MAX(0,B7-B8)

 

[HighAndWilder]

Copy selected column in range to another sheet.xlsm
	B	C	D	E	F	G	H
2	Clock In	Lunch From	Lunch To	Clock Off	Lunch	Hours	Overtime
3	08:00	12:21	12:40	17:28	00:19	08:00	01:09
4	08:00	12:45	13:27	17:21	00:42	08:00	00:39
5	08:00	12:39	13:20	17:32	00:41	08:00	00:51
6	08:00	12:35	13:00	17:35	00:25	08:00	01:10
Timesheet

Cell Formulas
Range	Formula
F3:F6	F3	=D3-C3
G3:G6	G3	=MIN("08:00",(E3-B3)-F3)
H3:H6	H3	=((E3-B3)-F3)-G3