J Judy Nov 28, 2004 #1 How do I format the times 10:30 AM to get 10:30A and 12:30 PM to get 12:30P? Thanks! Judy
R Randy Harris Nov 28, 2004 #2 Judy said: How do I format the times 10:30 AM to get 10:30A and 12:30 PM to get 12:30P? Thanks! Judy Click to expand... This is right out of the Access Help: Debug.Print Format(Time, "h:mmA/P") HTH, Randy
Judy said: How do I format the times 10:30 AM to get 10:30A and 12:30 PM to get 12:30P? Thanks! Judy Click to expand... This is right out of the Access Help: Debug.Print Format(Time, "h:mmA/P") HTH, Randy
S Steve Huff Nov 28, 2004 #3 Here is one way to do it for display purposes: =left(format(now(),"hh:mm ampm"),7) --Steve Huff
