Subtracting times

[gaftalik]

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 .

 

[Cutter]

Try this:

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

 

[gaftalik]

Thank you very muc

 

[Cutter]

You're very welcome