“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to convert 41:30hrs to a digital form. This formula only works up to 24hrs =(A2-INT(A2))*24 Many thanks

Solved by B. U. in 27 mins

I wanted to convert a value from centimeters to Inches and Feet. in the following format (0' 00'') and I am using the following forumla for this =INT(CONVERT(A1,"cm","ft")) & " '" & 12*(CONVERT(A1,"cm","ft")-INT(CONVERT(A1,"cm","ft"))) & """" The answer is accurate but the only Problem is The value of Inches has a lot of digits after decimal points.. Please help me how can I round off the Inches part of the value to two digits after decimal point? Please help me how can I improvise this formula Thanks Saram.

Solved by C. F. in 23 mins

I need a formula to convert a string of letters within a cell to numbers - abcdef to 123456

Solved by B. A. in 28 mins

I tried to convert a value into date but excel gave me a unique string referencing months and years instead.

Solved by V. B. in 19 mins

I need to convert a string of letters, example "NEEGVQE" which all in one cell and convert each letter into a number, example N= -3.5 E= -3.5 G= -0.4 V= 4.2 Q= -3.5 and then add those numbers up to get a value.

Solved by V. U. in 25 mins