John W. Colby
jwcolby at colbyconsulting.com
Thu Feb 12 21:47:42 CST 2004
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