Converting a cell to minutes

[Plusone]

Hello

I need to enter a number of hours into a cell and it will work out the amount in minutes. Obviously i could do this with a calculation in another cell (=sum(A1*60)...

However i need it to work it out in the cell that i put the number of hours in. For example i will enter 2 and it will change it to 180.

Is this possible?

Kind Regards,
Darren Stewart

[jetted]

Hi Darren

Put the following in module under worksheet.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
refere = Target.Address
target1 = Target * 60
Range(refere).Select
ActiveCell = target1
Application.EnableEvents = True
End Sub