How to convert seconds to hours

How to convert time from one unit of measure to another. For example, convert seconds to minutes and hours and vice versa.

You will need

Calculator

Instruction manual

one

To convert seconds to hours, it is enough to divide the number of seconds by 3600 (since 60 minutes in one hour and 60 seconds in every minute). To do this, you can use an ordinary calculator. Enough even the one that is available in almost any cell phone.

However, it should be borne in mind that the number of hours is likely to be fractional (in decimal: xy hours). Although the decimal format of the time representation (especially time intervals) is more convenient for intermediate calculations, such a representation is used relatively rarely as the final answer.

Depending on the specific task, you may need to indicate the time in the form: x hours y seconds. In this case, it is enough to completely divide the number of seconds by 3600 - the integer part of the division will be the number of hours (x), and the remainder of the division will be the number of seconds (y).

If the result should be a specific point in time (clock reading), then the solution will probably need to be presented in the form: x hours, y minutes, z seconds. For this, the number of seconds will first have to be completely divided by 3600. The resulting quotient will be the number of hours (x). The remainder of the division must again be completely divided by 60. The quotient obtained at this step will be the number of minutes (y), and the remainder of the division will be the number of seconds (z).

In order to solve the inverse problem, i.e. translate seconds into hours, all the above steps must be done in the reverse order. Accordingly, for the first case, the number of seconds will be xy * 3600, for the second - x * 3600 + y, and for the third - x * 3600 + y * 60 + z.

Although the use of the above method should not cause difficulties in single calculations, for large volumes of calculations (for example, processing of experimental data), this process can take a lot of time and also lead to errors. In this case, it is better to use the appropriate programs.

For example, using MS Excel, just enter the necessary formulas once to get ready-made results. Drawing up suitable formulas does not require programming skills from the user and is accessible even to a student. For an example, we will make formulas for our case.

Let the initial number of seconds be entered in cell A1.

Then in the first embodiment, the number of hours will be: = A1 / 3600

In the second option, the number of hours and seconds will be: = WHOLE (A1 / 3600) and = OSTAT (A1; 3600), respectively.

In the third embodiment, the number of hours, minutes and seconds can be calculated using the following formulas:

= WHOLE (A1 / 3600)

= WHOLE (OSTAT (A1; 3600) / 60)

= OSTAT (OSTAT (A1; 3600); 60)