calculation problem

  • Thread starter Thread starter avagodro
  • Start date Start date
A

avagodro

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?

I have also tried =TIME(0,0,162)
and format the result as time, but get a result back as 02:42, whic
would still be wrong
 
Hi
162 seconds = 2 minutes (120 seconds) + 42 seconds
so whats wrong with 2:42

Frank
P.S.: please stay in your previous thread - makes life easier for all
of us :-)
 
Based on your example 162 seconds do convert to 2mins 42
seconds.

There are 86400 seconds in a day so =162/86400 and
formatted to mm:ss will give you 2:42

Regards
Peter
 
This is not an issue of seconds to minutes and seconds. First you will have to realize how Excel handles time and division. If you use the INT function you can divide 162 / 60 and receive 2 which are the minutes. It is written as INT(162/60)
If you use the MOD function you can get the remaining seconds. It is written as MOD(162,60). Now is you return them in the Time function as you described you will get the actual time. It would be written as TIME(INT(162/60),MOD(162,60),0
There is your answer. Let me know how this worked for you
Jack
 
Back
Top