I use the following formula to calculate the hours worked between two times
I now want to include a further cell for the time taken for lunch
How should I format that cell and what formula do I use to subtract
this break time from the result of the formula above
So if cell C2 has 6:00 and cell Be has 21:00 and =TEXT(C2-B2, "h:mm") used in cell D2
shows a result of 15:00. What should I out in cell F2 to show one hour for lunch and then
what formula should I put in G2 to show the final hours including the lunch break?