Here is my field (Subject): Dialpad Call - Inbound / 13 min (# of minutes varies)
I want to create a formula so it pulls out the number of minutes: Here are a few formulas i've tried. They all come up blank:
VALUE(MID(
Subject,
24,
FIND( "/",Subject)-3
))
VALUE(
MID(
Subject ,
FIND("/", Subject) + 1,
FIND("/", RIGHT(Subject, LEN(Subject) - FIND("min", Subject)))
)
)
What am I doing wrong?
1 answer
Eric Burté (DEVOTEAM) 
Forum Ambassador
Hello @Mya Henk, could you please try something like
VALUE(
TRIM(
MID ( Subject,
FIND ("/",Subject) + 1,
FIND ("min",Subject) - FIND("/",Subject) - 2
)
)
)
Eric
