This is doing my head in, I'm sure its a dead simple solution but cannot get it to work..
Cell A1 contains a start time formatted as [hh]:mm
Cell B1 contains an end time formatted as [hh]:mm
Cell D1 contains lunch perriod formatted as number with two decimal places
Cell F1 contains total numbers hours worked formatted as [hh]:mm
Subtracting the end and start times I've for but problem is when I try and subtract the 1 for lunch.
(I've attached very simple excel sheet for ease)
Bookmarks