Combine time cell and function cell with new function

Hello all,
I'm trying to create a formula and am seeking your guidance. I have 2 colums both referencing time. Column A has time formatted as "2 min 41 seconds". Column B has a math function of "=2+(41/60)" to give a number.

What I would like to do is automatically fill column B with the values entered in Column A. So let's say I enter a time of 4 min 00 seconds, I would like the "4" and the "00" to populate the formula "=x+(yy/60)". If possible, I'd also like to display the MAX value in column A without changing the style from "general". Is any of this possible? Thank you in advance for your help.

Hi, and welcome to the forum. Unfortunately:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



I'll change it for you on this occasion but please note for the future.

Regards

Hi,

Why not just enter =A1*24 in B1 and format it as a number not a time.