id="info"

General discussion

Locked

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.

3 total posts (Page 1 of 1)  
| 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

=(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.

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 ...

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

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums