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

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.


Chad Cameron wrote:

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

Hi,
Custom format, enter

00":"00":"00

"Chad Cameron" wrote:

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


.