formating hours and minutes to 0.00 format

[live2ride]

dates.accdb
attached is what i have so far

[June7]

Field BAHoursMinutes is LongInteger type. This will not allow values with decimal. Must be Single or Double type (I use only Double).

Again, do you want to save value with decimal (like 2.5) for BAHoursMinutes? If you do, then change the field type. Also, the baHrsMin function is concatenting with colon instead of period. Might want to declare the function as Double instead of String but not critical, code should be able to save the value to Double field regardless. I can see you understand code to save value to field.

Just need to resolve questions of field type and how you want to round 15 minutes. Do you want to round according to your original function or by my first suggested expression? I also gave you an expression that could be used in textbox (or in code or in query) that would eliminate the custom function.

Don't know how else I can help you. This seems really quite simple and straightforward.

[live2ride]

changing field from LongInteger to Double did the trick. now i can add value with decimal. Thank you so much!