Time conversion help???
 

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

Thanks as always,

Time conversion help???
 

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,

Time conversion help???
 

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,