Issue
When exporting reports from FYI, the Time is displayed in a decimal format. How do I see it as hours and minutes?
Solution
Displaying the time in a decimal allows for calculations for better reporting, for example, total time, or capacity.
However, depending on their requirements, practices may need to display time using the h:mm format instead.
To change the displayed time into the hour and minutes format:
- In Microsoft Excel, add a heading to a blank column. In this example, we are using column K to display the "Actual" hours in hours and minutes, and enter the heading "Actual (h:mm)".
- Click on the Formula bar and enter the formula below:
=(cell)/24
where (cell) is the cell with the value we want to convert. In the example below, the cell is I2. - A decimal value will be shown - this will shortly be converted into the required format of h:mm.
- Select the cell with the formula entered in step 2.
- Hover over the corner of the cell until the icon changes to a + symbol, and double-click to add the formula to all cells in the column.
Tip: You can also copy/paste the cell to all of column K to add the formula for those cells. - Click on the column header to select the entire column. For example, click on the letter K to select all of column K.
- Right-click on the highlighted column and select Format Cells.
- On the Number tab, select the category of "Custom".
- In the Type list, scroll down and select "h:mm".
- Click OK.
- The column will be updated to display the time in the h:mm format.
Note: Xero Practice Manager can also be configured to display reports using a decimal (for comparing and reconciling data).