How to convert a number of seconds to a time format?
Ok, lets say you have a table with seconds in it.
| TimeInSeconds |
|---|
| 10 |
| 199 |
| 765 |
| 402 |
| 398 |
| 107 |
| 40 |
First use this function to convert it to a time based number:
Time#(TimeInSeconds,’ss’)
Second, wrap that
Time(Time#(TimeInSeconds,’ss’), ‘m:ss’)
Now your table will look like this:
| TimeInSeconds |
|---|
| 0:10 |
| 3:19 |
| 12:45 |
| 6:42 |
| 6:38 |
| 1:47 |
| 0:40 |
While there is more to this, as you will see with a wide range of data, this should get you started and you should be able to go from here.
