Subtracting times
 

Hi All,

How to subtract two different times and to obtain the results in
minutes ?

A1= 9:00
A2= 11:00

A2-A1 = 02:00 ( how could 2:00 be converted to minutes ?)

Thank you much .


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=481009

Subtracting times
 

Try this:

A2-A1 but format the cell using a custom format of [mm]


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=481009

Subtracting times
 

Thank you very much


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=481009

Subtracting times
 

You're very welcome.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=481009