Can I combine my two separate date/time fields ("short date" and .

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

Guest

I need to calculate time differences (in hours and minutes) across a couple
of days. The database is set up with a separate fields for date and time. Can
I combine these two fields to make a "general date" field, so difference
calculations will be easier?
 
You should be able to add them together
=[DateField]+Nz([TimeField],0)
 
You must log in or register to reply here.

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

Writing a General Date from separate date and time fields 3
Elapsed time using date and time fields 4
Date Format 5
date error 1
Time field for calculating past midnight 1
converting atomic fields to a single date time field 2
Calculating date/time intervals?? 1
Calculate Times 1

Back
Top