Extracting total hours

[jesita ajani]

Hi,
I would like to extract "the total hour of studying in a week" but the format of the values are like these:
00:00:00.000+03:00

Does anyone know how to do this?
Thank you!

[Andrew Musau]

Provide a dataex example. See FAQ Advice #12 for details.

[jesita ajani]

. dataex ess1

----------------------- copy starting from the next line -----------------------
[CODE]
* Example generated by -dataex-. For more info, type help dataex
clear
input str18 ess1
"02:00:00.000+03:00"
"04:00:00.000+03:00"
"04:00:00.000+03:00"
"03:00:00.000+03:00"
"08:00:00.000+03:00"
"05:00:00.000+03:00"
"03:00:00.000+03:00"
"06:00:00.000+03:00"
"03:00:00.000+03:00"
"03:00:00.000+03:00"
"07:00:00.000+03:00"

[Andrew Musau]

To calculate durations, you need a start time and end time. These appear to be times in the format "HH:MM:SS.SSS+HH:MM" and appear to be in the timezone with an offset of +03:00 hours. Do you have any more information about this variable?