If your 1414:00:00 was in cell A1, then in A2 type:-
=A1*24
Format cell A2 as a number

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Toria" wrote:

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!!