Need to convert "Xh YYm" to excel time format for operations, etc. Help! Thanks as always,
J Jon M Apr 14, 2009 #1 Need to convert "Xh YYm" to excel time format for operations, etc. Help! Thanks as always,
S Sheeloo Apr 14, 2009 #2 If you have hours in A1 and minutes in B1 =(A1*60+B1)/(24*60) will convert it into Excel date/time... You can split your values into hours and minutes by Data->Text to column by using space as the delimiter... If you also have h and mm then either you can search and replace them with nothing or use LEFT function to extract the numeric part.
If you have hours in A1 and minutes in B1 =(A1*60+B1)/(24*60) will convert it into Excel date/time... You can split your values into hours and minutes by Data->Text to column by using space as the delimiter... If you also have h and mm then either you can search and replace them with nothing or use LEFT function to extract the numeric part.
L Luke M Apr 14, 2009 #3 If your entry is in A2, formula to convert: =TIME(LEFT(A2,FIND("h",A2)-1),MID(A2,FIND(" ",A2)+1,2),0) Assumed that there is a space in entry, and that you are using the standard 2 digits for minutes (nothing like: 4h 132m)
If your entry is in A2, formula to convert: =TIME(LEFT(A2,FIND("h",A2)-1),MID(A2,FIND(" ",A2)+1,2),0) Assumed that there is a space in entry, and that you are using the standard 2 digits for minutes (nothing like: 4h 132m)
