try this

start time - 8.00 AM in cell A1
end time - 5:00 PM in cell B1
Break - 1 - in cell C1

in D1 put this formula

=(B1-A1)-(C1/24)



On Nov 17, 10:13*pm, Kris wrote:
Here is the scenario.

If I had a cell that had 8:00 formated in time (h:mm). *I wanted to subtract
1 from it to get an answer of 7:00, what would I need to do.

or lets say I had 8:00 and wanted to subtract .5, to return 7:30, what would
I need to do.