Time format behaviour

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.
 
T

Tom Ogilvy

I don't think that is required:

from the immediate window

depTime = #8:26#
? Format(DepTime, "HH" & "mm")
0826
 
Top