Converting hours to minutes and using the result...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=TEXT(A1,"[m]")

HTH
Jason
Atlanta, GA

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

I have been reading the time converting threads, but all
Click to expand...
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.
Click to expand...
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
Click to expand...
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,

You can use:

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

HTH,
Felipe
-----Original Message-----
Hello,

I have been reading the time converting threads, but all
Click to expand...
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.
Click to expand...
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
Click to expand...
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.
 
=(A1*1440)*RatePerMinute

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

Serdar Aytemiz said:
Hello,

I have been reading the time converting threads, but all of them use
Click to expand...
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
Click to expand...
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.
 
Back
Top