Discussion Locked

converting time into seconds

0 helpful

3 replies

by pra_m Aug 20, 2005 last reply Sep 22, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

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.

What does INT do?

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

This discussion is closed to new replies.