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 bkrike 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 clarias
-
Time difference (odd question)
Thanks Jonathon,<br><br>I have worked out how to use the datediff function but this leaves me with a value in hours.<br>I need to convert this into a normal number that I can use in a multiplication sum.<br><br>e.g. The difference between 05.30AM and 08.00 = 2.5hrs<br>I need to multiply the...- clarias
- Post #3
- Forum: Microsoft: Access Other topics
-
Time difference (odd question)
I am quite a newcomer to building databases,<br>My question is:<br>Can you set a default day to 05:30am on one day to 05:30am on the next day and then calculate the time difference between 05:30 and any other time in that 24Hr period as a decimal.<br>e.g. The difference between 05:30 and 01:30 =...- clarias
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
