-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
date/time calculation
- Thread starter andybrst
- Start date
Russell Hauf
MrExcel MVP
- Joined
- Feb 10, 2002
- Messages
- 1,611
Try the DateDiff function.
You could write your own function for this in VBA, or just do it in the query.
VBA:
Then you could use the above function in a query:
fldHours: HoursMins([fldDate1],[fldDate2])
There are other ways you can do this also - hopefully this give you a start. Note that if dt1 is later (more recent) than dt2, you'll get a negative number.
You could write your own function for this in VBA, or just do it in the query.
VBA:
Code:
Public Function HoursMins(dt1 as Date, dt2 as Date) as String
Dim lngMins as Long
lngMins = DateDiff("n",dt1,dt2)
HoursMins = (lngMins \ 60) & ":" & (lngMins Mod 60)
End FunctionfldHours: HoursMins([fldDate1],[fldDate2])
There are other ways you can do this also - hopefully this give you a start. Note that if dt1 is later (more recent) than dt2, you'll get a negative number.
Upvote
0
