Rock YouTube channel with real views, likes and subscribers
Get Free YouTube Subscribers, Views and Likes

Use Special Formatting plus formula to calculate the next time based on the minutes entered

Follow
Google Sheets Tutorials

‪@redtailfanschool‬ I had a reason to use this in a project recently. In cColumn B we typed a number of minutes, but display it as xx Minutes in the cell, then in column A we have a formula: =if(B2 = "", "", A2+TIME(0,B2,0)) that gives us the next time based on the number of minutes in the first cell. This formula is copied down in column A to achieve the results.

posted by sikayiseg1