Need to convert "Xh YYm" to excel time format for operations, etc.
Help!

Thanks as always,

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.
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Jon M" wrote:

Need to convert "Xh YYm" to excel time format for operations, etc.
Help!

Thanks as always,

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jon M" wrote:

Need to convert "Xh YYm" to excel time format for operations, etc.
Help!

Thanks as always,