473,508 Members | 2,342 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Storing Time Values

228 New Member
I am working on a small database and need some help.

Basically, it is employees in and out program. From vb6, I would calculate the difference between in and out and know for how long the employee has worked.

Now, the program works fine for times like this:

9-10,10:30-11:00 etc.

But from 12:00-1:00, it gives like 11 hours! I think the error is related to 12/24 hour format and I am so confused on how to deal with it.

I am not sure if this [Access Forum] is the place to post the question, but please guide me on how to deal with it.
Dec 9 '10 #1
1 1523
colintis
255 Contributor
There is a VB section in another part of this forum, so this is a wrong place for your question. Unless you are actually writing VBA in MS Access.

Also, please post out the code you work on that is related, otherwise its difficult for people to help you.
Dec 10 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1940
by: Tom Mortimer | last post by:
Hi, A quick question - can anyone tell me how to interpret negative time values in pstats.Stats.print_stats() output? Eg - 39052965 function calls (38035317 primitive calls) in -250.959 CPU...
0
1206
by: Ron Hocking | last post by:
When I link a MySQL table containing a TIME column to Microsoft Access the value does not display. If I edit the value it updates correctly in mysql but if I refresh the Access datasheet view the...
1
2507
by: gi75research | last post by:
What should be a very simple function is going terribly wrong, and I don't know why. StartTime and EndTime are table values (formatted like "01:00A" or "02:00P"); DaypartStart and DaypartEnd are...
14
1790
by: John Welch | last post by:
Hi all. I'm creating a FE/BE database that will be used by about 6 users. As usual, I have several fields, such as "OrganizationTypeID" that will get values (via combo boxes in forms) from separate...
4
11666
by: narayana | last post by:
hi gurus, I am kid at DB2 .problem is I am unable to insert values of time and date datatype fields into tables .default date datatype is taking 4bytes lenght so I am unable to insert date value...
11
2322
by: James Hallam | last post by:
I have read through all the past topics and couldn't find what I was after so... I am looking to store some calculated values (don't flame just yet, just read on!). I have an piece of code...
2
1197
by: MorrganMail | last post by:
Hi, I am writing an SQL query in which I need to compare two fields which are both storing time information. The datatype of the first field is Date/Time and the format is HH:MM. The second...
7
2294
by: grbeltran | last post by:
Hey everybody, I am having lots of trouble storing values in an array and I want to be prompt at the beginning of each value. The values I will enter will be two digit values such as 23, or 42,...
1
1695
by: madhura | last post by:
Hi, I need to compare some time values stored in a file in the following format & get the lowest of them. FORMAT - 16:12.433(mins:seconds.milliseconds) Can someone help me with the required...
1
2030
by: trevorjhughes | last post by:
I am running an import of some date/time values that have come from a Cognos query. These values are in a CSV file and I want to import them into access. The CSV file would show the value thus:...
0
7229
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7129
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
7061
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7502
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5637
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3208
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3194
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1566
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
769
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.