Hello all, I am in need of converting data into Minutes. The data format is fixed at ## Hours ## Min or just ## Min and I need it all in Minutes so I can calculate the time with other data. Thank you.
How to automatically convert (92 Hours 29 Min) in to Minutes
-
-
You would need another column. Your numbers aren't formatted as you say though
-
Column A is not formatted as time, they are in effect text so you cannot calculate with them
-
Try,
In E2, formula copied down :
=IFERROR(LEFT(A2,FIND("H",A2)-2),)*60-IFERROR(LOOKUP(1,-RIGHT(LEFT(A2,FIND("M",A2)-2),ROW($1:$99))),)
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!