Calculation problem

[Steve]

I have a spreadsheet in which I am trying to calculate
seconds into minutes. However, when I do so, it converts
incorrectly.
The example: I am trying to convert 162 seconds into
minutes. I have tried 162/60, and CONVERT
(162,"sec","mn"), and each time I get a value of 2.7.
There is no such thing as 2.7 minutes. It should be
returning 3.1 minutes.
Any suggestions?

 

[Frank Kabel]

Hi Steve
try
=TIME(0,0,162)
and format the result as time

Frank

 

[Guest]

I tried that, and get a result of 02:42. It should be
03:10. Am I doing something wrong?

 

[Frank Kabel]

Hi
qas posted in your new thread:
162 seconds = 2 minutes and 42 seconds!
so 2:42 is correct. How did you calculate a value of 3:10 minutes?
Frank