Subtracting One Time Cell From Another

[lukerees83]

I'm working on an excel 2003 spreadsheet with the cells formatted to hh:mm

I currently have a very simple calculation to subtract one time from another =(K10-E10)

The result of the above calculation is 02:06, which is correct.

However, I need to have a formula which does the above calculation and then subtracts a further 25 minutes. In this case the answer needs to show 01:41.

I presume I can't just add -25 to the end of the formula because the hh:mm format doesn't permit it.

How do I program the formula to remove those extra 25 mins?

 

[asking]

25 Minutes is 0:25:0
If you put that in one cell and subtract that from 2:06:0

=2:06:0-0:25:0
Cheers

 

[JamesW]

Hi,

Try:

=((A1*1440)-B1)/1440

Where A1 is your calculated time, and B1 is the number of minutes you want to subtract. Format as hh:mm.

 

[jasonb75]

The simple way is

=(K10-E10)-"0:25"