Does anyone know how to subtract two times from each other and get the answer
in the number of minutes?

Hi

Try
=(A2-A1)*24*60
due to there being 24 hours in a day and 60 minutes in an hour.

--
Andy.


"Zoombini" wrote in message
...
Does anyone know how to subtract two times from each other and get the
answer
in the number of minutes?

Hi Zoombini,

Does anyone know how to subtract two times from each other and get the answer
in the number of minutes?


Simply subtract them and format the cell as [m]:ss

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Zoombini wrote:
Does anyone know how to subtract two times from each other and get the answer
in the number of minutes?


8:15 7:45 30.00

=(A1-B1) * 24 * 60
FORMAT
HH:MM HH:MM NUMBER