Security, Privacy, AI and CSR information for all Piano products now lives in one place. Explore our Compliance Center.
Analytics
English French
English French

How do I format raw time data in Excel?

When you export time spent data from Piano Analytics, you get raw values that Excel doesn't format as a duration. You can display them as "hh:mm:ss" in two steps: convert the values, then apply a custom cell format.

Excel stores a time as a fraction of a day, so a value in seconds must be divided by 86400, the number of seconds in a day. For example, 3600 seconds (one hour) becomes 0.0416667, which Excel can display as "01:00:00".

  1. Divide the value by 86400, then copy the formula down through all your values.

If the metric is expressed in milliseconds, use (CELL/86400)/1000 instead of CELL/86400.

2023-04-20_12h12_22-20240926-082319.png
2023-04-20_12h12_51-20240926-082357.png
  1. Change the format of the cells to a custom format: "hh:mm:ss".

2023-04-20_12h15_15-20240926-082716.png
2023-04-20_12h15_34-20240926-082751.png

Last updated: