<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="71"/>
        <last_saved_by value="Easy_Data_Transform_v1_47_1_on_Windows_10_Version_2009_at_2025_02_05_11_46_36"/>
        <locale value="en_US"/>
        <id value="7702050c337707030b7476010b0b38"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="T%3A%5CDownloads%5CSumTime.transform"/>
        <auto_run_on value="0"/>
    </meta>
    <inputs>
        <input pos="-329.4^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-329.4-45" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="0" custom_delimiter="%2A" ignore_repeated_delim="0" text="Time%0A00%3A30%3A00%0A00%3A15%3A00%0A02%3A15%3A00%0A00%3A45%3A00%0A03%3A15%3A00%0A00%3A45%3A00" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="1" name="Javascript" pos="-90^-284.4" pos_v12="-90-284.4">
            <parameters>
                <parameter type="7" name="New_Name" value="ms"/>
                <parameter type="6" name="Type_As" value="Number%2FBoolean%2FString"/>
                <parameter type="12" name="Script" value="const%20%5Bhours%2C%20minutes%2C%20seconds%5D%20%3D%20%24%28Time%29.split%28%27%3A%27%29.map%28Number%29%3B%0Areturn%20%28hours%20%2A%203600%20%2B%20minutes%20%2A%2060%20%2B%20seconds%29%20%2A%201000%3B"/>
            </parameters>
        </transform>
        <transform id="9" name="Javascript" pos="149.4^-164.7" pos_v12="149.4-164.7">
            <parameters>
                <parameter type="7" name="New_Name" value="Time"/>
                <parameter type="6" name="Type_As" value="Number%2FBoolean%2FString"/>
                <parameter type="12" name="Script" value="const%20totalSeconds%20%3D%20Math.floor%28%24%28ms%29%20%2F%201000%29%3B%0Aconst%20hours%20%3D%20Math.floor%28totalSeconds%20%2F%203600%29%3B%0Aconst%20remainingSeconds%20%3D%20totalSeconds%20%25%203600%3B%0Aconst%20minutes%20%3D%20Math.floor%28remainingSeconds%20%2F%2060%29%3B%0Aconst%20seconds%20%3D%20remainingSeconds%20%25%2060%3B%0A%0Aconst%20pad%20%3D%20%28n%29%20%3D%3E%20String%28n%29.padStart%282%2C%20%270%27%29%3B%0Areturn%20%60Total%20Time%3A%20%24%7Bpad%28hours%29%7D%3A%24%7Bpad%28minutes%29%7D%3A%24%7Bpad%28seconds%29%7D%60%3B"/>
            </parameters>
        </transform>
        <transform id="10" name="Stack" pos="-90^74.7" pos_v12="-9074.7">
            <parameters>
                <parameter type="6" name="Align_Cols" value="Header%20name"/>
                <parameter type="5" name="Only_First_Cols" value="0"/>
                <parameter type="5" name="Add_Separators" value="0"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
            </parameters>
        </transform>
        <transform id="11" name="Remove" pos="-90^-45" pos_v12="-90-45">
            <parameters>
                <parameter type="11" name="Columns" value="3"/>
            </parameters>
        </transform>
        <transform id="18" name="Stats" pos="149.4^-284.4" pos_v12="149.4-284.4">
            <parameters>
                <parameter type="1" name="Columns" value="2"/>
                <parameter type="6" name="Calculation" value="Sum"/>
                <parameter type="8" name="Percentile" value="90"/>
                <parameter type="6" name="On" value="Columns"/>
            </parameters>
        </transform>
        <transform id="19" name="Filter" pos="-90^-164.7" pos_v12="-90-164.7">
            <parameters>
                <parameter type="3" name="Columns" value="1112Sum"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="0" end_id="1"/>
        <connection start_id="0" end_id="10"/>
        <connection start_id="1" end_id="18"/>
        <connection start_id="9" end_id="11"/>
        <connection start_id="11" end_id="10"/>
        <connection start_id="18" end_id="19"/>
        <connection start_id="19" end_id="9"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
