General discussion


converting time into seconds

By pra_m ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by collignond In reply to converting time into seco ...

It is actually simple

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

The formula looks as follows


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.

Collapse -

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

by UAddUp In reply to

What does INT do?

Collapse -

by chitosunday In reply to converting time into seco ...

change your cell format to number

Related Discussions

Related Forums