Time format behaviour

  • Thread starter Thread starter Frank Stone
  • Start date Start date
F

Frank Stone

I'm not sure about this but try it. I think your problem
is the the format you want is not available. to make it
available goto edit>cells>custom. In the type box enter
HH:mm. now the format is available.
 
I don't think that is required:

from the immediate window

depTime = #8:26#
? Format(DepTime, "HH" & "mm")
0826
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting short times 2
New time format 5
Finding Date in an overseas format 20
Extract time from date 4
Date conversion doesn't make sense 3
Format Msgbox - time HH:mm 2
Time format 1
microsoft office web components wizard in office 2010 0

Back
Top