Prev: how do i stop excel from converting numbers entered into a date
Next: grouping Radio Buttons; Using ActiveX Controls
From: Chad Cameron on 6 May 2010 10:55
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


From: Dave Peterson on 6 May 2010 11:53
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
From: Eduardo on 6 May 2010 12:40
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
>
>
> .
>
 | 
Pages: 1
Prev: how do i stop excel from converting numbers entered into a date
Next: grouping Radio Buttons; Using ActiveX Controls