View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
dk_ dk_ is offline
external usenet poster
 
Posts: 70
Default Is there a way to enter times without typing a colon?

Yep, that works.

Thank you.

I'll study the formula and try to figure it out.

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture


In article ,
"David Biddulph" wrote:

Sorry, my error. That formula was one I'd given as answer to someone who
wanted to enter number in the format 09.30. For your format, it needs to be
=TIME(INT(A1/100),100*MOD(A1/100,1),0)
--
David Biddulph

"dk_" wrote in message
...
David,

I copied your formula in B1.

I entered 0930 in A1

The result was 6:00 PM in B1

I don't see what this formula should do.

I was trying to find a way to enter 0930 or 930, with no colon to be
computed in a formula as 9:30 AM.

Thanks.

-Dennis


In article ,
"David Biddulph" wrote:

=TIME(INT(A1),100*MOD(A1,1),0)




--
Dennis Kessler
http://www.denniskessler.com/acupuncture