[AccessD] integer in hh:mm format

Gustav and Stuart,

it works fine with one or the other way
many thank's both of you



----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, May 28, 2009 3:13 PM
Subject: Re: [AccessD] integer in hh:mm format


> In which case,
> Int(Duration/60) & ":" & format(duration mod 60,"00)
>
>
> On 28 May 2009 at 14:07, Gustav Brock wrote:
>
>> Hi Kostas
>>
>> Yes, but you will miss the leading zero for minutes less than 10.
>> See my previous post for a simple method to add that.
>>
>> /gustav
>>
>> >>> kost36 at otenet.gr 28-05-2009 14:01 >>>
>> I just use
>> Total_Time: Int([DURATION]/60) & " hrs. " & ([SumOfDURATION] Mod 60) & "
>> minutes."
>> cause I don't know how to syntax the hhh:mm format
>>
>> thank's again
>>
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>