Search results

Found a simple way to do it in Query. Format((Int([START_TIME])+(([START_TIME]-Int([START_TIME]))/0.6))/24,"Short Time") Thanks

Thanks for that. Almost there... The base data is stored on a server and accessed via an odbc connection; so I don't have any say in how it's stored. I've got a query (then report) which displays working start times and end times for employees. The code works great except for: 1) Any time...

Hi, I'm pretty new to Access (using 2003) and need some guidance. I have 2 numeric fields in a table. They are both time stored as number format but the number 9 represents 09:00 and the number 17.3 respresents 17:30. I want to create a new field which combines the two fields together...