Convert DLOOKUP text to Long Time format

R

RAFarrar

Joined
Sep 11, 2013
Messages
6
Reaction score
0
I have a dlookup that is returning the following format:
10:03:24 PM
Problem is that this is not in the Long Time format. How do I go about making this field in Long time Format?

NxtTime: DLookUp("[Time]","tbl-Tech-Scans-1","[SeqID]=" & [SeqID]+1)

Thanks!
 
Back
Top