I was trying to calculate the hours worked for a single employee on a specific day. Went crazy trying to get the thing to work. This simple formula worked for me.
Values...
Column A = time in, Column B= Time out (sometimes after midnight)
Column C = Total hours worked.
Make sure all your cells are formatted to the 24 hr clock (13:30)
FORMULA
=(24-A2+B2)
Use the 24 hrs. minus the time in + time out.
It seemed to work for me.
Bookmarks