Subtract one time from another and get answer in minutes

[Guest]

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

 

[Guest]

Hi

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

 

[Jan Karel Pieterse]

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

 

[RdB]

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