Time in Seconds Only

[Chad Cameron]

Hi All,

I have to enter a bunch of times that are less than 1 minute. Is there an
easier way to enter times than 0:0:15?

I would like to just enter 15 and have it recognize that it is 15 seconds,
not hours.

Thanks
Chad

 

[Dave Peterson]

You could enter the seconds and use a formula in a helper column, like:

=A1/24/60/60
and format the result as a time.

Or you could use something like:
x14
x12
x49

Then finish the data entry.
Select your range
Edit|Replace
what: x
with: 0:0:
replace all

Excel should see the entries as time.

 

[Eduardo]

Hi,
Custom format, enter

00":"00":"00