To calculate the hours worked minus a half hour for lunch, you can use the following formula in Microsoft Excel:

Here's how you can use this formula to calculate the hours worked in your example:

1. In a blank cell, type the equal sign (=) to start the formula.
2. Click on the cell containing the time out value (14:30 in this case).
3. Type a minus sign (-) to subtract the time in value.
4. Click on the cell containing the time in value (6:00 in this case).
5. Type another minus sign (-) to subtract the half hour lunch break.
6. Type 0.5 to subtract the half hour lunch break.
7. Press Enter to calculate the result.

The formula should look like this: Assuming that the time in value is in cell B1 and the time out value is in cell B2, the result should be 8.00, which represents the number of hours worked minus the half hour lunch break.