Hello!
My dataset includes exams information:
1. starttime - the hour the exam started
2. duration_hours - the exam duration in hours.

Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str5 starttime double duration_hours
" 9:00" -1.8934488e+12
" 9:00" -1.8934452e+12
" 9:00" -1.8934452e+12
" 9:00" -1.8934452e+12
" 9:00" -1.8934488e+12
" 9:00" -1.8934488e+12
" 9:00" -1.8934452e+12
" 9:00" -1.8934488e+12
" 9:00" -1.8934488e+12
end
format %tcHH:MM:SS duration_hours
I would like to convert the format of these two variables.
It should look like this for starttime:
Orginial starttime New starttime
9:00 900
10:30 1030
14:30 1430
and for duration_hours:
Original duration_hours New duration_hours
15:30 1530
18:00 1800
I want to use this variables for calculations so I need them in int storage type.

Thanks in advance!