I actually didn't.

But maybe I misinterpreted.

If I have 00:01:30 (90 seconds), but I made a mistake during data entry--I
really wanted 01:30:00 (90 minutes), I'd multiply by 60.



Ragdyer wrote:

I believe Dave might have meant:

=A1/60

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
=a1*60
and format nicely.

grandma wrote:

I want to change minutes to hours as a function. How?
--
grandma

--

Dave Peterson

--

Dave Peterson