Solved

Date/Time Calculations.

Posted on 1998-08-27
1
126 Views
Last Modified: 2010-04-30
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?
0
Comment
Question by:chiefboats
1 Comment
 
LVL 8

Accepted Solution

by:
MikeP090797 earned 50 total points
ID: 1431487
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

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vb.net 2008 2 60
Add a task in Outlook from access 11 39
Protecting vb6 & .Net code Obfuscation 18 125
VBA - If Bookmark = "XXBOOKMARKXX" then 15 29
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question