Time conversion

[Tee]

Hi,
How would I convert a number (100) into hours and minutes?

Thanks

 

[Guest]

-----Original Message-----
Hi,
How would I convert a number (100) into hours and minutes?

Thanks
.
I had several people working on this and it was only

possible to do this by creating a prog. in VB and setting
it up as a Macro in Excel.....

This is what they came up with:

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 2/7/2002 by PCModem
Dim saversec
Dim getit As Integer
Dim savermin As Integer


getit = ActiveCell
saversec = (getit Mod 60)
savermin = (getit / 60)

'""HH:mm"")"
ActiveCell = savermin & ":" & saversec



End Sub

 

[Peo Sjoblom]

Assuming it is minutes

=A1/1440

format as [h]:mm

 

[Guest]

Thanks very much - that works a treat!

-----Original Message-----

possible to do this by creating a prog. in VB and setting
it up as a Macro in Excel.....

This is what they came up with:

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 2/7/2002 by PCModem
Dim saversec
Dim getit As Integer
Dim savermin As Integer


getit = ActiveCell
saversec = (getit Mod 60)
savermin = (getit / 60)

'""HH:mm"")"
ActiveCell = savermin & ":" & saversec



End Sub
.