Search results
-
K
Time to decimal conversion
The field that I'm trying to convert to decimal has been produced by the following code: Function GetElapsedTime(interval) Dim totalhours As Long, totalminutes As Long Dim Hrs As Long, Min As Long totalhours = Int(Nz(CSng(interval * 24))) totalminutes = Int(Nz(CSng(interval * 1440))) Hrs =...- Keith166
- Post #8
- Forum: Modules & VBA
-
K
Time to decimal conversion
Short Time Conversion Nope! still getting a SHORT TIME????- Keith166
- Post #3
- Forum: Modules & VBA
-
K
Time to decimal conversion
I'm a novice needing to convert a short time value to a decimal so that a calculation of Time X Rate of Pay can be made. I've tried the following Microsoft code after resetting the format to short time but I still get a short time result. Public Function timetodec(Time1) timetodec = CDbl(Time1)...- Keith166
- Thread
- Replies: 12
- Forum: Modules & VBA
-
K
Booking Times
I have created a database using access 97 which is used to register players tee off times at my golf club. A tee off time report is then created and emailed out of access to the pro shop. My problem is that sometimes the opertator inadvertantly enters 5 names instead of 4 for a tee off time...