exel colums

A

aly1cat

I have two queries:

1. what is the formula for changing a time into minutes. i.e I have
cell that states 2.56.25 and I need it to display in minutes only.

2. How do I separate details in just one cell into two or more cell
i.e A1 contains Mrs Alison Thomas and I want Mrs in A1, Alison in B
and Thomas in C1?

Thank
 
F

Frank Kabel

Hi
1. Is this stored as Excel time (with a dot as format) or is this a
text string? If it's a text string use the following formula
=TIME(--LEFT(A1,FIND(".",A1)-1),--MID(A1,FIND(".",A1)+1,FIND(".",A1,4)-
FIND(".",A1)-1),--MID(A1,FIND(".",A1,4)+1,2))
and format this cell with
[mm]:ss

2. Use 'Data - Text to<columns' for this
 
A

aly1cat

No it is entered as a time format e.g 02:15.33 - how do I change or wha
is the formula for changing to complete minutes
 
F

Frank Kabel

Hi
then jst format this cell with the custom format
[mm]:ss

or to get the minutes as decimal value use the formula
=A1*24*60
and format this cell as number
 
Top