Difference between two times, less half-hour

[dunlopoil]

Hi,
I want to calculate the difference between two times (these will always be in the same day, and will not span midnight). For example:

Start time (Cell B2): 08:30:00
End time (Cell C2): 18:00:00
Duration (Cell D2): 08:30:00

I now want to subtract 30 minutes lunch period from this calculation.

Many thanks,
Doug.

 

[VoG]

Try

=C2-B2-"00:30"

 

[dunlopoil]

Thanks- for some reason I thought it would be more complicated than that!