How to use time filed in indicator
Posted: Wed Jun 23, 2021 6:01 pm
Hi ,
I have below data and want to show average of all times in an indicator:
ROW | Time |
1 | 8:00 |
2 | 8:10 |
3 | 8:50 |
I couldn't find any way to do this. so I tried converting time to number:
I converted data to:
ROW | Time |
1 | 8.00 |
2 | 8.17 |
3 | 8.83 |
In this way I can show value 8.33 as value inside indicator.
But It's more desirable to see 8:20 inside indicator.
is there any solution or trick?
I have below data and want to show average of all times in an indicator:
ROW | Time |
1 | 8:00 |
2 | 8:10 |
3 | 8:50 |
I couldn't find any way to do this. so I tried converting time to number:
I converted data to:
ROW | Time |
1 | 8.00 |
2 | 8.17 |
3 | 8.83 |
In this way I can show value 8.33 as value inside indicator.
But It's more desirable to see 8:20 inside indicator.
is there any solution or trick?