converting hours to minutes w/o VBA
 

I am currently trying to convert hours to minutes or numbers to
minutes... for example if I take 1127 -812, I get either 315 general
number or 3:15 in time format (if all numbers are in time format)... if
I go this way, I would like to convert the time to show minutes or 105
as a general number. The other way would be to keep the general
number, but then this problem occurs... 1002-926=76, when in fact it is
36 minutes. overall, I am looking at only inputing numbers in 2 colums
and 10 rows... would like to keep it to simple number input in all
coulms and rows as well as final answer as it will be used regularly by
other people. any ideas? Thanks Jerry




--
herosuper

converting hours to minutes w/o VBA
 

If times are in hh:mm format, then set cell with subtraction to format Custom
==[mm] to give time in minutes.

HTH

"herosuper" wrote:


I am currently trying to convert hours to minutes or numbers to
minutes... for example if I take 1127 -812, I get either 315 general
number or 3:15 in time format (if all numbers are in time format)... if
I go this way, I would like to convert the time to show minutes or 105
as a general number. The other way would be to keep the general
number, but then this problem occurs... 1002-926=76, when in fact it is
36 minutes. overall, I am looking at only inputing numbers in 2 colums
and 10 rows... would like to keep it to simple number input in all
coulms and rows as well as final answer as it will be used regularly by
other people. any ideas? Thanks Jerry




--
herosuper

converting hours to minutes w/o VBA
 

Or, =(A1-B1)*24*60 formatted as general.

"herosuper" wrote:


I am currently trying to convert hours to minutes or numbers to
minutes... for example if I take 1127 -812, I get either 315 general
number or 3:15 in time format (if all numbers are in time format)... if
I go this way, I would like to convert the time to show minutes or 105
as a general number. The other way would be to keep the general
number, but then this problem occurs... 1002-926=76, when in fact it is
36 minutes. overall, I am looking at only inputing numbers in 2 colums
and 10 rows... would like to keep it to simple number input in all
coulms and rows as well as final answer as it will be used regularly by
other people. any ideas? Thanks Jerry




--
herosuper

converting hours to minutes w/o VBA
 

maybe I don't get your problem, but how about formatting the cells you use
as time-format? just enter the time, it will show as hh:mm and excel will do
the calculations for you.

Tieske


"herosuper" wrote in message
...

I am currently trying to convert hours to minutes or numbers to
minutes... for example if I take 1127 -812, I get either 315 general
number or 3:15 in time format (if all numbers are in time format)... if
I go this way, I would like to convert the time to show minutes or 105
as a general number. The other way would be to keep the general
number, but then this problem occurs... 1002-926=76, when in fact it is
36 minutes. overall, I am looking at only inputing numbers in 2 colums
and 10 rows... would like to keep it to simple number input in all
coulms and rows as well as final answer as it will be used regularly by
other people. any ideas? Thanks Jerry




--
herosuper