Need formula for cell D4 that returns the hours (in whole hours & decimal of hours) by subtracting cell B4 (end time) from cell A4 (start time) both of which are formatted Time (1:30 PM) and subtracting cell C4 (Lunch time). For Example:

_|___A____|____B___|___C__|___D___
3|StartTime|End Time | Lunch_|Hrs Wkd
4|_8:00 AM| 5:00 PM_|__1.25_|__7.75

Thanks a lot. mikeburg