Excel time formulas

[blkane]

Hi,

I'm looking for a simple formula that will calculate the difference between a start and an end time then subtract 30 min.

So, for example, the start time is 7:00 am and the end time is 4:00pm. I can calculate the time difference but I don't know how to then modify the formula to subtract 30 min. I feel like I'm missing something very simple.

Thanks
Brenda

 

[petertenthije]

=endtime - starttime - (30/60/24)

30 minutes break
60 minutes per hour
24 hours per day

 

[blkane]

Perfect - Thanks so much!