Date/Time Calculations.

After using Excel and Access and using date/time in calculation I'm no having much luck with vb5. I need to find elapsed time between two date and time.  All I get is an integer answer in days only. I need it in days and fraction of days. Do I have to convert the date/time to serial number first before doing the calculation?
chiefboatsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MikeP090797Connect With a Mentor Commented:
You can use DateDiff to get the interval between to dates/times in any units you specify, it can be days, weeks, months, or even minutes.

D=DateDiff("h", D1, D2)
will get the interval between D1 and D2 in hours
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.