Ahhh, I now see the problem
A light finally shone in my head.
The problem is the figure entered in as the time taken for lunch.
Using Kees example above,
A1 = a time
B1 = a time, but
C1 = a number, (of minutes).
So, each of the cells A1, B1 and C1 must be formatted as either Time, or Custom, (hh:mm).
Then D1 =B1-A1-C1, and D1 must also be formatted as a Time, or as Custom, (hh:mm).
And, as Swisse has said, you must enter each number in the format 00:00, eg hours:minutes, so a 25 minute lunch break becomes 00:25
So, back to your original request,
B7 =time started work, in the format hh:mm
C7 =time finished work in the format hh:mm
D7 =time spent having lunch, hh:mm
then E7 =C7-B7-D7
Highlight all the cells and right click. Select "Format cells"and in the Format Cells dialogue, select "Custom" from the list on the left.
Then, under the "Type" heading on the right, delete any entry, and type in "hh:mm" (without the quotation marks), then click OK.
You could just format the cells as "Time", but this gives results in the hh:mm:ss format.
Hope this helps.
Was this reply helpful? (0) (0)