A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Excel Formula Help
Tyler Marais
0
Reputation points
Hello,
I would like to know if what I want can be done and possibly how???
Think of it like a timer with A and B cells used.
A = minutes
B = seconds
For the sum of say B3 and onward for every 60 seconds can you have it +1 minute and rest at 0 seconds?
Instead of the sum in one cell read as 65 make it read as...
A2 = 1
B2 = 5
And then instead of 120 in just one cell it reads as
A2= 2
B2 =0
And then so for for every +60?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
Sign in to answer