Hello,
I put the Start Time in B2, End Time in B3, and "Minutes of Breaks" in B4. Use the formula below:
=(IF(B2>B3,1+(B3-B2),B3-B2)-(B4/60/24))*24
Because of the way the times work, if you work overnight, you'll have to take 1 + your number otherwise you will be shorted. Time is technically Month/Day/Year Hours:Minutes:Seconds in excel. It gave you a negative number because it assumes you worked on 1/0/1900. So you actually worked back in time.
Hope this helps,
Bookmarks