Wochen&tage in Minuten umwandeln

[snb]

Verwende ein UDF:


In B2 :

PHP-Code:

=F_snb(A2) 


Code:

Function F_snb(c00)
    sn = Split(c00)
    
    For j = 0 To UBound(sn)
        y = y + Choose(InStr("wdhmn", Right(sn(j), 1)), 10080, 1440, 60, 1, 1) * Val(sn(j))
    Next
    
    F_snb = y
End Function