Share via

Excel Formula Help

Tyler Marais 0 Reputation points
2026-06-12T04:40:23.7466667+00:00

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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.