Subtract one time from another and get answer in minutes

Zoombini · Apr 21, 2005

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

Guest · Apr 21, 2005

Hi

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

Jan Karel Pieterse · Apr 21, 2005

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 · Apr 22, 2005

Zoombini said:
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