Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

timediff()

Status
Not open for further replies.
phpatrick

phpatrick

Programmer
Jul 9, 2006
72
0
0
BE
You have the function DateDiff to get the number of day between two days.
What is the most easy way (function) to get the minutes, hours between two times.

Code: 
setuptime 14:00 finish time 17:18 = 3:18

I should put this function in a where clausule of my query.
 
Sort by date Sort by votes



Hi,

Same function. Time is the fractional part of Date in units of DAYS.
[tt]
Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second
[/tt]

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
Upvote 0 Downvote
What about this ?
CDate(finishtime-setuptime)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top