Hello,
Your help is greatly appreciated! Thank you in advance.
Cells

A2 9:00am
B2 7:00pm
C2 [please provide a formula that will automatically deduct a 1 hour lunch break]
D2 [please provide a forumla that will calculate time worked over 7 hours]