# Discussion on: converting time into seconds

4

### Join the conversation!

Just In
###### Why do you need -INT(C7) in the formula?
What does INT do?

Tags: software

View:
Show:
###### 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
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.
###### Why do you need -INT(C7) in the formula?
What does INT do?
chitosunday@... 21st Aug 2005
=A1*24*60*60
change your cell format to number
Keyboard Shortcuts:
Prev
Next
Toggle
###### Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
• [b] Bold [/b]
• [i] Italic [/i]
• [u] Underline [/u]
• [s] Strikethrough [/s]
• [q] "Quote" [/q]
• [ol][*] 1. Ordered List [/ol]
• [ul][*] · Unordered List [/ul]
• [pre] Preformat [/pre]
• [quote] "Blockquote" [/quote]

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