[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