Assuming start time in A1, and End time in A2
=A2-A1


"Martin" wrote:

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