Time Format Conversion

[Sklotz163]

Hey there!


I am trying to pull the amount of time a case stays as a certain status in Jira, but I am unable to pivot the format in which Jira exports time.


Is there a way to convert the following format into just minutes?


1 h, 48 m, 30 s


I would like the value above to become 108.5 so I can create a pivot table.


I am just manually converting everything into minutes at the moment, so any advice to streamline this process would be much appreciated.


Thanks!

 

[Gary's Student]

Try the following User Defined Function:

Public Function JustMinutes(sIN As String) As Double
    ary = Split(sIN, ", ")
    JustMinutes = 0
    For Each a In ary
        bry = Split(a, " ")
        If bry(1) = "h" Then JustMinutes = JustMinutes + bry(0) * 60
        If bry(1) = "m" Then JustMinutes = JustMinutes + bry(0)
        If bry(1) = "s" Then JustMinutes = JustMinutes + bry(0) / 60
    Next a
End Function

 

[Sklotz163]

I really appreciate the quick response.

This works perfect for what I need!

Thank you!!