entering time in a form

[Indigobuni]

I have set up a basic timesheet for the employees. Everyone wants to enter the data differently, so I need some help on making it simple.

1. Is there a way to let them enter time without the ":" (ex. 900 = 9:00 or 1100 = 11:00)

2. Is there a way to let them enter the time without having to hit AM or PM? (I do not want to use military time if I can help it)

3. Is there a formula that will calculate the total time instead of them entering it?
Example

Time In Time Out Total Time
8:00am 12:00pm 4.0
1:30pm 5:00pm 3.5

Thanks for any help.

 

[namliam]

In this thread we get into time calcs....

 

[Indigobuni]

Ok, now that I'm thoroughly confused after reading all 3 pages of responses from that thread LOL...

Let's skip the calculations of time ok. I don't know anything about VB or SQL statements. I taught myself Access and know enough to do what I need to do (most of the time).

Can you help me with the first two questions? I had a hard time sorting through those postings and couldn't tell if this was even covered in there.

1. Is there a way to let them enter time without the ":" (ex. 900 = 9:00 or 1100 = 11:00)

2. Is there a way to let them enter the time without having to hit AM or PM? (I do not want to use military time if I can help it)

Thanks so much!

 

[namliam]

1. use an input mask: 00:00, this will force the : allowing users to enter only the true time
2. if you have hours only from 8:00 am to 7:59 PM then you might be able to have some logic:
<8:00 = PM
>= 8:00 <= 12:00 am

Or have a check box (checked = am unchecked PM or something)

The thing about the other thread (in verry short) is if you have 2 times and want to know the difference:
Time1 = 8:00
Time2 = 20:00
Time2 - Time1 = 0.5
Time is part of a day, 1 day (24 hours) equals 1 thus 12 hours = 0.5
So if you want to have the "real" hours in "real" numbers
(Time2 - Time1 ) * 24 = 12

Hope that clarifies it a bit...

Hope i helped you on 1 and 2....

Regards

The Mailman

 

[WayneRyan]

Indigo,

Also see the Help Files for the TimeSerial function. That will
let your users enter them in any way that they are familiar
with and you can collect the pieces into a valid time for
use in calculations.

Wayne