Convert Seconds to Hours

Question

I'm working with time duration that comes in seconds. I've already converted the metric to hh:nn:ss, but that won't work for our purposes as we need a sum or average to show for whatever time frame the end user selects. Two alternatives were suggested, but I'm unable to get the DAX formula to work.&nbsp;&nbsp;I'd like to convert seconds to hours so 30 min shows as .5 and so on. I've been unable to find a formaula for this, however.&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;SChariton&nbsp;,
&nbsp;
As&nbsp;lbendlin&nbsp; said, you can divide the seconds value by 3600 to get the hour value. Detailed steps are shown below.
1. Based on your description, I created this data.

2. Create a calculated column or measure and write an expression. In this example I created a calculated column. For more information about the divide function, please refer to the documentation: DIVIDE function (DAX) - DAX | Microsoft Learn.
hour = DIVIDE('Table'[sec],3600)
3. The results can be formatted in the table tool, in this example I kept the results to 3 decimal places.

4. The final result is shown in the figure below.

&nbsp;
If your Current Period does not refer to this, please clarify in a follow-up reply.
&nbsp;
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Related content

Convert Days, Hours, Minutes and seconds in to Seconds

Convert seconds into hour minute and seconds

Convert Seconds to Hours and Mins

Convert Seconds to DD:HH:MM:SS

Using Dynamic Formatting to convert seconds to hours, minutes and seconds