Time format

From: Paul (anonymous_at_discussions.microsoft.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 00:31:04 -0700

Hi everyone,
Can somebody help me with this problem.
What do i change in the format and inputmask properties, when i want to enter a time value in a textbox.
When i change the format property to R and the inputmask to 99:99 it displays as 9999 e.g If time entered is 18:00 it displays as 1800.
Kind regards
Paul

Relevant Pages

  • Re: Use TextBox Text As Function Name!
    ... the text in the TextBox changes to "<the name of the ... > OptionButton that was checked just before the selection change>2<the ... You have some design issues here. ... using the most common format. ...
    (microsoft.public.vb.general.discussion)
  • Re: Newbie question on formatting a field in table design
    ... Each department field is set to the default format ... multiplies the number entered by 100 and adds the "%" sign. ... right of the textbox, then store the number that way and do the ... normalized table design would convert your 11 ...
    (comp.databases.ms-access)
  • Re: Custom Cell Format problem
    ... I am having trouble with this "raw" TextBox. ... when I paste the contents of the UserForm into a new row on the sheet ... I have raw data in the format of 3 numbers, ...
    (microsoft.public.excel.programming)
  • Re: Deleting Rows and Shifting Up - Repost
    ... Kind regards, ... "Dave Peterson" wrote: ... The first column of data I format the numbers in the column to 1 decimal ... Dim iLastRow As Integer ...
    (microsoft.public.excel.misc)
  • Re: Deleting Rows and Shifting Up - Repost
    ... Kind regards, ... The first column of data I format the numbers in the column to 1 decimal ... When I run the algorithm the everything on my sheet is deleted. ... Dim iLastRow As Integer ...
    (microsoft.public.excel.misc)