Date and Time, Only want time...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I easily pull only the time out of a date and time field? I've tried
timevalue(), but this doesn't work. Can anyone help?
 
Tess said:
How do I easily pull only the time out of a date and time field?
I've tried timevalue(), but this doesn't work. Can anyone help?
Click to expand...

What are you wanting to do? Are you trying to save just the time,
display the time on a form or report, or do you want to use the time in some
sort of calculation?
 

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

separating Date and Time 2
Matching on Dates & times 21
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
timevalue function 3
Assigning shift to Time Intervals using IIF 6
Excluding weekends and holidays from date results. 1
Date/Time Text. 5
Access query 7

Back
Top