Discussion on:

converting time into seconds

4

Comments

Add Your Opinion

Join the conversation!

Follow via:: RSS; Email Alert

Just In

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

UAddUp 22nd Sep 2009

What does INT do?

Community Preferences

View:

Please Select

Show:

Please Select

0 Votes

+ -

converting time into seconds

pra_m@... 20th Aug 2005

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

0 Votes

+ -

collignond@... 21st Aug 2005

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.

0 Votes

+ -

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

UAddUp 22nd Sep 2009

What does INT do?

0 Votes

+ -

chitosunday@... 21st Aug 2005

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

Keyboard Shortcuts:: Prev; Next; Toggle

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.

Join Login