Need some help with leading zeros with hh:nn.  I have a function that adds
times (in short time format) and gives the result in hh:nn format.  If the
minutes are less than 10 I only get one digit for minutes.  Here is the last
part of code:

    totalhours = Int(CSng(interval * 24))
    totalminutes = Int(CSng(interval * 1440))
    Hours = totalhours Mod 24
    minutes = totalminutes Mod 60

 SevenDay = Format(totalhours & ":" & minutes, "hh:nn")

I'm using Access 97 and any help is appreciated.

Ron

I am not sure what you are trying to do. The hours and Minutes are
calculated but not used.

If you have two fields are  in short time, then the simplest way would
be to
Format(Timediff,"hh:mm")

alternately, you can calculate the difference in minutes and then

intHours =inttotalminutes \ 24               ' gives the quotient only
inMinutes = inttotalminutes mod 24       ' gives the remainder only

and diff = format(intHours,"00") & ":" & format(intminute,"00")

Nirmala Sekhar

--------------------------------------------------------------------------------------------
{*filter*} Software Consultant / Developer
--------------------------------------------------------------------------------------------