Hours Minutes to Minutes...VBA/Excel

[jamada]

Trying to convert hours to only minutes, however not certain what I'm doing wrong here, looking at the table O does not equal the minutes in N!
Tks Graham

Part of my code is as follows;

Columns("O:O").Select
Selection.NumberFormat = "0"

Dim Lastrow As Long
Lastrow = Range("A" & Rows.Count).End(xlUp).Row
Range("Q2:Q" & Lastrow).Formula = "=(11&""/""&LEFT(RC[-10],2)&""/""&14&"" ""&MID(RC[-10],3,2)&"":""&RIGHT(RC[-10],2))"
Range("P2:P" & Lastrow).Formula = "=(11&""/""&LEFT(RC[-3],2)&""/""&14&"" ""&MID(RC[-3],3,2)&"":""&RIGHT(RC[-3],2))"
Range("N2:N" & Lastrow).Formula = "=RC[3]-RC[2]"
Range("O2:O" & Lastrow).Formula = "=LEFT(N2,2)*60 +RIGHT(N2,2)"


Columns("N:N").Select
Selection.NumberFormat = "hh:mm"

Excel 2010
	N	O
1	HH:MM	Minutes
2	00:10	88
3	01:08	54
4	00:35	71
Sheet2

Cell Formulas
Range	Formula
N2	=Q2-P2
N3	=Q3-P3
N4	=Q4-P4
O2	=LEFT(N2,2)*60 +RIGHT(N2,2)
O3	=LEFT(N3,2)*60 +RIGHT(N3,2)
O4	=LEFT(N4,2)*60 +RIGHT(N4,2)

 

[MARK858]

If N2 is a real time it should just be

=N2*24*60

Edit: Format the cells as number rather than time.

 

[jamada]

MARK858........ Worked very well in deed....... Thank You Very Much..... Happy New Year!
Graham

Range("O2:O" & Lastrow).Formula = "=(N2*24*60)"

 

[Jon Peltier]

If you have a properly formatted time, that is, it is a fractional number formatted as hh:mm to display hours and minutes, you can format it as [mm] to show minutes only. 0:10 becomes 10, 1:10 becomes 70, 2:10 becomes 130, etc.