VBA formula

I get an excel spread sheet from a client that has cells showing hours and minutes separated with a decimal.

Say 40 hours, 59 minutes is displayed:
40.59

I need to convert that to decimal minutes so the above should become:
40.98

I found a formula online that does this conversion in another cell.

Please Login or Register  to view this content.

Can i create a vba script to run this formula on a range of cells and have the result of the formula overwrite the original cell's value?



I've created the Range so far...

Please Login or Register  to view this content.

where do i go from here?

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.