Hello,

I have a column that has minutes in this format: 1414:00:00. I need it to
just say 1414. I was trying to do that with the LEFT function. However, if
you look in the edit bar, 1414:00:00, really is 2/27/1900 10:00:00:00 PM.
Can anyone help to just get this to say 1414?

Thank you!!