Time and Expenses: Strangeness with hundredth decimal place
Recently I started recording/tracking my time with a solution that could be narrowed down to the hundredth decimal place. (0.01, 0.02....)
The strange part is, for certain numbers of the hundredth decimal place, they automatically change the number to a closer one. At first I thought it is a fixed rounding, but after testing all numbers from 1-9, I found that there doesn't seem to be a particular pattern. The following is my test result, please advise.
0.01 NO it becomes 0.02
0.02 Yes this one works
0.03 Yes this one works
0.04 No it becomes 0.03
0.05 Yes this one works
0.06 No it becomes 0.07
0.08 Yes this one works
0.09 No it becomes 0.08
Answer (1)
Hello Yihuan,
What you are seeing is actually expected behavior for time entry at this time.
This is because of the way time is stored, it is actually stored in an integer (not decimal) amount of minutes. The UI translates this between a decimal amount of hours to an integer amount of minutes and back. Though you cannot actually save the time in terms of minutes, only as hour values through the UI.
Ideally we would allow time to be entered directly as hours and minutes and/or allow partial minutes, but right now that isn't allowed by the time entry system.
I would definitely advise that you submit this as an enhancement request though to allow more flexibility with the values that can be entered for time entries. If we get more requests from unique clients then there is a higher likelihood that it will receive attention in a future updated version. Enhancements can be entered from the Submit a Product Idea button on the solutions.teamdynamix.com page.
Sincerely,
Mark Sayers
TD Support