Working with Time Data

[SherriKilgore]

I have an issue where the time is stored as a number (example 742 = 7:42AM, 1942 = 7;42PM). I need to convert this to time, from military to 12 hour so I can calculate the hours worked for an employee between their time clock punches. Thanks for any ideas you can give.

 

[Mihail]

Have you, always, 2 "decimals" ?

 

[David R]

CDate() is remarkably flexible as long as you give it something like a valid datetime stamp. Do you have the 'date' portion of the clock punch in another field?

For instance:

CDate([DateField] & " " & Left([TimeField],Len([TimeField])-2)& ":" & Right([TimeField],2))

Put that in a calculated field in your query. I believe in Access you'll have to do that in one query, and then compare the login/logout in a second-level query, but I may be mistaken.