how to express a number as a time

[palaeontology]

I have a number in cell J2 ... let's say the number 7

I wish, in cell K2, for that number to be expressed in the mm:ss time format, so it should look like 7:00

Because, ultimately, I wish to make each successive cell below K2 add one minute to the time above it, so K3 would read as 8 minutes (8:00), K4 would read as 9 minutes (9:00) etc etc etc

This last part is simple to do with the formula ... =K2+time(0,1,0), but I can't figure how to do the first part of my question.

Any ideas ?

Kind regards,

Chris

 

[Fluff]

How about
=J2/1440

 

[palaeontology]

Thanks Fluff ... I feel stupid .. I had been multiplying by 1440 instead.

Ta again,

Chris

 

[FormR]

Hi, you could also use =TIME(0,J2,0) which would add a little consistency to your method for adding the subsequent minutes.

 

[Fluff]

Thanks Fluff

You're welcome & thanks for the feedback