ExcelBanter - Subtract one time from another and get answer in minutes

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Subtract one time from another and get answer in minutes (https://www.excelbanter.com/excel-discussion-misc-queries/22992-subtract-one-time-another-get-answer-minutes.html)

Zoombini

Subtract one time from another and get answer in minutes

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?

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

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

All times are GMT +1. The time now is 11:03 AM.