CUSTOMER ZONE

How to convert Decimal Hour Format to HH:MM Format?

Find resources designed to help you get the most from Replicon

By default, Web TimeSheet displays the Time in Decimal Hour format. The user can change the way how Time is displayed on his Timesheet by clicking on the Settings button which is found at the top right corner next to the Logout button. Here, under the 'Edit User Preferences' screen a user can change the Hours format to either Decimal or HH:MM however, changing this preference will only affect the way how Time is displayed on Timesheet but Web TimeSheet Reports would still show Time only in Decimal format.

To understand Time better in HH:MM format or to convert Time from Decimal to HH:MM format, use the following formula in Microsoft Excel, =TEXT(C6/24, "h:mm")

Alternatively, we could make use of the Custom Column in Web TimeSheet Reporting Functions.

For certain Time Off Reports, we could use the formula mentioned below to view the Time Off Hours in HH:MM format,

Left(NumberToText(TimeOffHours), Len(NumberToText(TimeOffHours))-3) +"h"
+ " " +
Left(NumberToText((TimeOffHours-Floor(TimeOffHours))*60),
Len(NumberToText((TimeOffHours-Floor(TimeOffHours))*60))-3
)+"m"

For certain Time Reports, we could use the formula mentioned below to view the Total Hours in HH:MM format,

Left(NumberToText(TotalHours), Len(NumberToText(TotalHours))-3) +"h"
+ " " +
Left(NumberToText((TotalHours-Floor(TotalHours))*60),
Len(NumberToText((TotalHours-Floor(TotalHours))*60))-3
)+"m"

To view the Regular Hours in HH:MM format, in the User Hours Detail Report, use the following formula,

Left(NumberToText(RegularHours), Len(NumberToText(RegularHours))-3) +"h"
+ " " +
Left(NumberToText((RegularHours-Floor(RegularHours))*60),
Len(NumberToText((RegularHours-Floor(RegularHours))*60))-3
)+"m"

Note:
Refer the attached screenshots and (.xls) file for more details.

Attachment:

Decimal converter for Excel

Start a free Replicon trial today based on your business needs

Start Free Trial