I have 1.5 mile run times recorded in seconds. I would like to keep this variable as seconds for the analyses I am running (i.e. regression). But I would like to display the format as mm:ss for the output in graphs and tables. I.e. the way you can display the date in any format, but it leaves the numbers the same (days from 1/1/1960).

Data is below: 3 variables: First_Run is the run time in seconds. first_run2 is just First_Run / 60. first_run 3 I generated with: .egen first_run3 = hmmss(First_run). first_run2 doesn't help as it's in the wrong format. first_run3 displays correctly, but it's a string and therefore unusable for analyses.

Appreciate any help/insight and I apologize if this is too basic for this forum!
Ben

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long First_Run float first_run2 str8 first_run3
571  9.516666 "09:31"
632 10.533334 "10:32"
571  9.516666 "09:31"
607 10.116667 "10:07"
539  8.983334 "08:59"
579      9.65 "09:39"
579      9.65 "09:39"
595  9.916667 "09:55"
550  9.166667 "09:10"
576       9.6 "09:36"
620 10.333333 "10:20"
564       9.4 "09:24"
654      10.9 "10:54"
562  9.366667 "09:22"
599  9.983334 "09:59"
694 11.566667 "11:34"
587  9.783334 "09:47"
666      11.1 "11:06"
646 10.766666 "10:46"
625 10.416667 "10:25"
  0         0 "00:00"
618      10.3 "10:18"
621     10.35 "10:21"
651     10.85 "10:51"
642      10.7 "10:42"
549      9.15 "09:09"
684      11.4 "11:24"
602 10.033334 "10:02"
573      9.55 "09:33"
640 10.666667 "10:40"
559  9.316667 "09:19"
635 10.583333 "10:35"
677 11.283334 "11:17"
  .         . ""     
745 12.416667 "12:25"
657     10.95 "10:57"
648      10.8 "10:48"
  .         . ""     
694 11.566667 "11:34"
648      10.8 "10:48"
end