Converting hours to minutes and using the result...

[Serdar Aytemiz]

Hello

I have been reading the time converting threads, but all of them use formatting the cell to show the result. and formated results cant be used in formula
Why do I need this. I have per minute payment figure. there for I have a formula as follows

(usage minutes)*(perminute price

the times are entered as 02:05 (hr:mn). I need a formula that gives me 125 (minutes) in the cell not by formatting. I need the actual number to work with. I have done this by using convert to text then using the left 2 and right 2 letters and do a calculation. I am sure there is an easier way

Best wishes

Serdar Aytemi

 

[Jason Morin]

=TEXT(A1,"[m]")

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

I have been reading the time converting threads, but all

of them use formatting the cell to show the result. and
formated results cant be used in formula.

Why do I need this. I have per minute payment figure.

there for I have a formula as follows;

(usage minutes)*(perminute price)

the times are entered as 02:05 (hr:mn). I need a formula

that gives me 125 (minutes) in the cell not by
formatting. I need the actual number to work with. I have
done this by using convert to text then using the left 2
and right 2 letters and do a calculation. I am sure there
is an easier way.

 

[Felipe]

Serdar,

You can use:

=HOUR(A1)*60+MINUTE(A1)

HTH,
Felipe

-----Original Message-----
Hello,

I have been reading the time converting threads, but all

of them use formatting the cell to show the result. and
formated results cant be used in formula.

Why do I need this. I have per minute payment figure.

there for I have a formula as follows;

(usage minutes)*(perminute price)

the times are entered as 02:05 (hr:mn). I need a formula

that gives me 125 (minutes) in the cell not by
formatting. I need the actual number to work with. I have
done this by using convert to text then using the left 2
and right 2 letters and do a calculation. I am sure there
is an easier way.

 

[Aladin Akyurek]

=(A1*1440)*RatePerMinute

where A1 houses a true time value (hh:mm).

Hello,

I have been reading the time converting threads, but all of them use

formatting the cell to show the result. and formated results cant be used in
formula.

Why do I need this. I have per minute payment figure. there for I have a formula as follows;

(usage minutes)*(perminute price)

the times are entered as 02:05 (hr:mn). I need a formula that gives me

125 (minutes) in the cell not by formatting. I need the actual number to
work with. I have done this by using convert to text then using the left 2
and right 2 letters and do a calculation. I am sure there is an easier way.

 

[Serdar Aytemiz]

Thank you all for the replies. It is working flawlessly. (N/t)