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

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

"dk_" wrote in message
...
It there a way to enter times without 'typing' a colon in an empolyee
time sheet, and still be able to add the number of hours worked?

...For example, type 0930 and 2130 instead of having to type either 9:30
or 09:30 and 21:30, and still be able to do the math on figuring the
number of hours worked in a day?

Thanks.

-Dennis