Forum Discussion
Adham
Helper III
Helper IIIPlotting Duration as continuous line graph
Hello All, I am have been stuck on this for a while and i would really appreciate help on this. I have got experimental data where i have got several readings for each experiment and the duration...
AdhamHelper III
Helper IIIHow can i convert hh:mm:ss into decimal? I think it would work if it was in hh:mm or mm:ss but in my case it is slightly different
AllisonKennedy
Community Champion
Community ChampionI think Power BI handles this in a similar way to Excel - assuming that 1=1day=24hours=1440minutes = 86400seconds
So for converting hh:mm:ss into decimal you would basically take
(24/hh)+(1440/mm)+(86400/ss)
If you wanted to you could customize this and set 1 hour = 1 and update the above formula, depending on what units you want on your axis.
So for converting hh:mm:ss into decimal you would basically take
(24/hh)+(1440/mm)+(86400/ss)
If you wanted to you could customize this and set 1 hour = 1 and update the above formula, depending on what units you want on your axis.