Inputting Time

  • Thread starter Thread starter parls
  • Start date Start date
P

parls

I am creating a time sheet database based on excel spreadsheets. The user is
used to entering start times and end times in a military format without
colons. For example: he enters start time as 630 and the data is converted to
6:30 am in another cell. I want to duplicate this action in access. I can't
figure out how.

Thanks,
parls
 
On Tue, 2 Mar 2010 08:25:01 -0800, parls

Perhaps you could have a second textbox and set the controlsource to:
=Left$(myTextbox,2) & ":" & Right$(myTextbox,2)
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
 
parls said:
I am creating a time sheet database based on excel spreadsheets. The user
is
used to entering start times and end times in a military format without
colons. For example: he enters start time as 630 and the data is converted
to
6:30 am in another cell. I want to duplicate this action in access. I
can't
figure out how.

Thanks,
parls
Click to expand...
 
Back
Top