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

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

hi
excel keeps time as a percent of a day. if you reformat your time to
general, you will see that it is 58.91666667 days. this is the real value
that is in the cell, formated at time.
you see 2/27/1900 10:00:00 in the formula bar because it is 58 days 10 hours
from the base start point which is 1/1/1900.
so to get it to say 1414 with out the cell true value and time formating,
multiply 1414:00:00 by 24(hours in a day) 58.916667 time 24= 1414
this will strip all time/date reference from the results meaning that you
will not be able to add 1414 to 1:00:00 and get 1415.
read up on how excel keep time/date. otherwize you will be posting here alot.

Regards
FSt1


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