Software·43,882 discussions

converting time into seconds

Locked

hello all ,

do u have any formula to convert time tin to seconds in excel.. that is if i put 1:20:00 time in cell it shoule give result to 4800 (seconds).

thanks and rgds

Topic

Reply To: converting time into seconds

In reply to converting time into seconds

It is actually simple

If your value 1:20:00 is in cell C7

The formula looks as follows

=(C7-INT(C7))*24*60*60

where the 24 is the number of hours in decimal
first 60 is the number of min and second 60 is the number of seconds.

Why do you need -INT(C7) in the formula?

In reply to Reply To: converting time into seconds

What does INT do?

Reply To: converting time into seconds

In reply to converting time into seconds

=A1*24*60*60
change your cell format to number

[Author]

Replies