S srburk Registered User. Local time Today, 10:54 Joined Dec 31, 2002 Messages 32 Jul 27, 2004 #1 How do I pull out AM or PM from a given time? For example... 1:13 pm In column 2, I'd like it to automatically put PM. I was thinking... Session: Format([Time],"___") but I'm not sure what to put as ___.
How do I pull out AM or PM from a given time? For example... 1:13 pm In column 2, I'd like it to automatically put PM. I was thinking... Session: Format([Time],"___") but I'm not sure what to put as ___.
W WayneRyan AWF VIP Local time Today, 16:54 Joined Nov 19, 2002 Messages 7,122 Jul 27, 2004 #2 Scott, Right(YourTimeField, 2) Wayne
ReAn Dangerous Programmer... Local time Today, 09:54 Joined Jun 25, 2004 Messages 250 Jul 27, 2004 #3 Expression: IIf(Hour([Timefield])>=12,"PM","AM")
