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!

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

Recent content by pquintan

  1. pquintan

    Hours between two dates

    Hi, My date is of the type DD/MM/YY HH:NN:SS. But when I substract one from the other doesn't work. I have used the DateDiff()function : DateDiff("s",db1.open_time,db1.close_time ) and this gave me the number of seconds of difference. Then, "playing" with this I can obtain...
  2. pquintan

    Hours between two dates

    Hi, I need to show how many hours and minutes are between two dates. Is this possible? And what about this with working hours? Let's say that I just want to take into account time spent between 08:00 and 17:00.

Part and Inventory Search

Back
Top