[AccessD] Expressing seconds in hours / minutes / seconds

On 12 Feb 2004 at 22:47, John W. Colby wrote:

> Well... I was really hoping for a "check writer" kind of interpretation,
> Three minutes and fifty one seconds.
> 
> However I can always revisit this later if necessary so I'll go with yours.
> 
> Thanks,
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
> McLachlan
> Sent: Thursday, February 12, 2004 10:06 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Expressing seconds in hours / minutes / seconds
> 
> 
> On 12 Feb 2004 at 21:32, John W. Colby wrote:
> 
> > Does anyone have a "second count to time in words" function?  NNN seconds
> =
> > A minutes and b seconds.
> 
> INT(secs\60) & " minutes and " & secs - INT(secs/60)*60 & " seconds"
> 
> 
> 
> 
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
> 
> 
> 
> _______________________________________________
> 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

I've actually got a "cheque writer" function stored away but it works in 
100s.

Give me a while to dig it out and do a quick mod.




-- 
Stuart McLachlan
Lexacorp Ltd
Application Development,  IT Consultancy
http://www.lexacorp.com.pg