Datediff Function

Y

Yvette

How do I get this fuction to NOT round off to the nearest
hour????? in ACCESS 2000 (I'm tring to obtain exact total
hours)

I've tried:

DateDiff("m",[startdate],[enddate]))/60
or
DateDiff("nn",[startdate],[enddate]))/60

These do not work!!

I've also tired:

DateDiff("h",[startdate],[enddate])

This rounds to the nearest hours, and I need the exact
hours.
 
J

Jim Sloan

Yvette;

DateDiff("n",[startdate],[enddate]))/60

this will give hours to the nearest 1/60 of an hour. Make sure that the
field/control isn't formatted as an integer.

Jim
 

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

startdate, enddate to display the duration such as 0 days 01:01 1
Nz function not showing all records 2
DateDiff ("m", StartDate,EndDate) 1
datediff, count excluding holidays 8
Help with Code and Working Days including Holidays 14
Query Question 1
DateDiff calculation 3
Help with my function vba code 1

Top