Try this:

A2 = Time in
B2 = Time out

Shift hours
H2 = 6:30 AM
I2 = 2:30 PM

D2 = formula for morning hours:

=IF(COUNT(A2:B2)<2,"",(IF(B$2<H2,0,IF(A$2I2,0,IF( B$2I2,I2,B$2)-IF(A$2<H2,H2,A$2)))/(B$2-A$2)*(B2-A2+(B2<A2)))*24)

E2 = formula for elsewhere hours:

=IF(D2="","",(B2-A2+(B2<A2))*24-D2)

Biff

"Martin" wrote in message
...
I am trying to create a time sheet where all time worked between 6:30 am to
2:30 pm goes in one column, and time else where goes in another column.
For
some reason my company tracks hours worked between 6:30 am and 2:30 pm.

Can anyone help?

--
Martin