Change Time Format to only seconds

J

Javier Gomez

Hi everyone!

I have a problem in which I would like to input the time in a cell in a
minutes:seconds format and in another cell I want to have the total number
of seconds (so I can use it to calculate something else).

For example-

1 minute and 34.56 seconds (which are 94.56 seconds)

First cell-> 01:34.56
Second cell-> 94.56

Is this possible? How so? Any help would be greatly appreciated :)
 
F

Fred Smith

Excel stores times in fractions of a day. To get from time to hours,
multiply by 24, to minutes, multiply by 24*60 (1440), to seconds by 24*60*60
(86400).

So your second cell = first cell *24*60*60. Format as a number.
 
R

Ron Rosenfeld

Hi everyone!

I have a problem in which I would like to input the time in a cell in a
minutes:seconds format and in another cell I want to have the total number
of seconds (so I can use it to calculate something else).

For example-

1 minute and 34.56 seconds (which are 94.56 seconds)

First cell-> 01:34.56
Second cell-> 94.56

Is this possible? How so? Any help would be greatly appreciated :)
Click to expand...

If you want to keep it in EXCEL time format, then merely format the cell as

.00


--ron
 
Top