time formatting module

[Guest_imported]

Hello,

I want to create a module that will take a number representing minutes, and return the time in a hh:mm format.

I created the function to do this, but I need some help in formatting the time that gets returned.

Right now I have two variable that holds the hours and minutes.

Any help would be appreciated.

Thanks

Gary

 

[JoeMiller]

If the minutes never go about 59 then you can use this:

MyResult = MyHours & ":" & format(MyMinutes,"00&quot


HTH Joe Miller
joe.miller@flotech.net