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
|