Reading time: 3 minutes
Topics explored in this article:
Converting hours
Runrun.it has three reports that show the time in decimal form: General Status Report, Timesheet per Client and Time by stage. To access them, simply go to the Company tab and click on Reports.
Important: only administrators and managers can view all the Reports. Team leaders can only view their team's data.
To convert the time to hours and minutes format (XX:XX) there are two possibilities:
Simple calculation
This conversion can be done in any spreadsheet, Excel, Google Spreadsheets, etc.
1) Keep the values that come before the comma (this will be the value in hours).
2) Multiply the values after the comma by 0.60 (this will be the value in minutes).
Example: 10.75 = 10 hours and 0.60 x 75 = 45 minutes.
Calculating in excel
1) Convert the hours in the report using the formula "=hour/24" (Equals sign and hour value divided by 24).
2) Then click on the time cell with the second button and choose "Format Cells...> Time". That's it!
In the topics below you will see examples of conversion in the time columns of Spreadsheet reports and how to apply the two conversion options presented above.
General Status Report
In the example below, we're going to convert the numbers in the Already recorded h column to Hours in the General Status Report.
To make the conversion easier, first split the numbers before and after the comma into different columns. With the new column (created only with the numbers after the comma) apply the formula =0.60*value to the cell in Column 1.
Then you'll have the value of hours in the column Already entered h and the value of minutes in Columns 1.
Check out the steps:
Insert column on the left
Select the column "Already registered h"
Click on the DATA tab in excel
Select the "Text for columns" icon
Follow the steps: Delimited > Next > Comma > Next > Finish > OK
Now you will enter the following formula in each column: =0.60*value in the "Columns 1" cell and click Enter
Do this for all the columns and convert the values!
Timesheet per Client
In the example below we will convert the numbers in the Total hours column to Hours in the Timesheet by Client report using the second calculation example.
To make the conversion, create a new column, divide the numbers in the Already recorded column by 24 and then convert the format to hours.
Here's how:
Click with the right mouse button Insert > Table column on the left.
In Column 1 enter the following formula: =[@[Total hours]]/24 and click Enter
Select Column 1
Click with the right mouse button and follow: Format Cells... > Time > 37:30:55 > OK
The conversion is ready!
Final message
We have listed some articles below that may interest you. And you already know: if you have any questions, talk to us via chat or send an e-mail to help@runrun.it.
Read also: