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
-
Apologies royUK I forgot to say only the Data Column (A) is what i get so i need a way of converting column A into only Minutes, Columns B and C was me trying to figure it out apologies.
-
Column A is not formatted as time, they are in effect text so you cannot calculate with them
-
Yep hence I need to convert it to Minutes so I can calculate with it, but thank you for your assistance.
-
-
-
bosco_yip WOW you genius! thank you soooo much this worked as expected, thank you again!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!