How to change the hours in the Payroll Report from Decimal to HH:MM format?
Find resources designed to help you get the most from Replicon
Any report when ran will show hours in decimal. If the report is extracted to an Excel file and exported to any other financial software, it will transfer the hours in decimal and not in hours:minutes. This means, that the time transferred will be more than actual because 00:30 will show 0.50 in a report and the financial software will read it as 50 minutes.
To resolve this issue, create a custom column such that it converts the hours from decimal to hours:minutes and then export it to an Excel file so that the correct time can be imported. To create the custom column, follow the steps given below:
Left(NumberToText(Hours), Len(NumberToText(Hours))-3) +"."+