Why is time converted from decimals to hours:minutes?
QuickBooks Online automatically converts decimal time entries into the hours:minutes format. This is the standard behavior for the product and cannot be changed.
For example, if you enter 1.5 hours, QuickBooks Online converts it to 1:30 (1 hour and 30 minutes).
Decimal to minutes conversion chart
If you need to enter time in decimals, use this chart to see how QuickBooks Online converts the values:
| Minutes | Decimal | Minutes | Decimal | Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|---|---|---|---|
| 1 | .02 | 16 | .27 | 31 | .52 | 46 | .77 |
| 2 | .03 | 17 | .28 | 32 | .53 | 47 | .78 |
| 3 | .05 | 18 | .30 | 33 | .55 | 48 | .80 |
| 4 | .07 | 19 | .32 | 34 | .57 | 49 | .82 |
| 5 | .08 | 20 | .33 | 35 | .58 | 50 | .83 |
| 6 | .10 | 21 | .35 | 36 | .60 | 51 | .85 |
| 7 | .12 | 22 | .37 | 37 | .62 | 52 | .87 |
| 8 | .13 | 23 | .38 | 38 | .63 | 53 | .88 |
| 9 | .15 | 24 | .40 | 39 | .65 | 54 | .90 |
| 10 | .17 | 25 | .42 | 40 | .67 | 55 | .92 |
| 11 | .18 | 26 | .43 | 41 | .68 | 56 | .93 |
| 12 | .20 | 27 | .45 | 42 | .70 | 57 | .95 |
| 13 | .22 | 28 | .47 | 43 | .72 | 58 | .97 |
| 14 | .23 | 29 | .48 | 44 | .73 | 59 | .98 |
| 15 | .25 | 30 | .50 | 45 | .75 | 0 | .00 |