Prev: skriv dansk
Next: Data-type issue
From: Mitchell on 13 Feb 2010 10:51
I want to format a cell for 24 hour time that will automatically add colons
for hr:min:ss plus allow a zero to be used at the beginning of any 24 hour
times before 10 am.

This is a log sheet for logging response times at a fire department. It
will not be necessary for any of these times to be used for data collection,
etc.

THANKS!
From: Daniel Pineault on 13 Feb 2010 10:56
You can simply use the format property to display date/time fields as you
please or use the Format() in vba.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Mitchell" wrote:

> I want to format a cell for 24 hour time that will automatically add colons
> for hr:min:ss plus allow a zero to be used at the beginning of any 24 hour
> times before 10 am.
>
> This is a log sheet for logging response times at a fire department. It
> will not be necessary for any of these times to be used for data collection,
> etc.
>
> THANKS!
 | 
Pages: 1
Prev: skriv dansk
Next: Data-type issue