Convert DLOOKUP text to Long Time format

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!
 

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

Dlookup VBA for multiple dates 0
DLookUp Format 4
Dlookup 7
Help with DLookup! 3
Subtracting time...again 2
Dlookup help needed 4
Excel Convert Datetime Stamp to HH and MM Worked 7
convert time format 2

Top