Difference between two times

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

Guest

How to calculate difference between two times (same date)?
Example: First time = 6.30 Second time = 9.00
Difference must be: 2.30

Btw. can I copy time value from one textbox to second in Default Value
property, how?
Thanks!
 
The DateDiff function calculates time differences too, but it only will let
you choose a single unit. If you wanted that format, you'll have to do it
yourself as

DateDiff("n", [FirstTime], [SecondTime]) \ 60 & "." & Format(DateDiff("n",
[FirstTime], [SecondTime]) Mod 60, "00")
 
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

Error -2147352567 (80020009), Access 2007 0
difference between two time 3
Cumulative time calculation in Excel 2003 2
Difference between 2 time stamps 5
Pivot table macro filter data between yesterday and today (date+time) 0
How to calculate diffrence between two dates 1
Adjust Date if Start time -> Stop time is overnight 6
Access Access - Elapsed Time between Records 5

Back
Top