Time / shift comparison -
I am working on a project that uses working shifts. These shifts have different starting/endig times and are stored in an Access db as date/time fields. Whenever I need to know how many minutes a shift lasts I try to use the datediff() function.
The problem is when a shift ends at 12:00 pm because vb will take that time as 0:00, so a shift that starts at 16:00 and ends at 24:00 instead of bringing a time difference of 8 hours gets me a time difference of 16 hours. The same goes when a shift starts, let's say at 10:00 PM and ends at 6:00 AM.
Any workarounds?
Thanks for any help.
Time / shift comparison -
I am working on a project that uses working shifts. These shifts have different starting/endig times and are stored in an Access db as date/time fields. Whenever I need to know how many minutes a shift lasts I try to use the datediff() function.
The problem is when a shift ends at 12:
Resolved Time locking in vb -
In vb6 i want write the codes to lock the application software
by time i have three working shifts shift 1 is from 7:00am to 3:00pm
shift 2 is from 3:00pm to 11pm and shift 3 is from 11:00pm to 7:00am
when the user starts the application he will prompt to put the shift i want chec
how to do time comparison in VB -
i have a problem in time comparison.
i want to compare system time with given fixed time & want to get result in hh:mm:ss format.
plz help..............
Newbie Needs Help - Comparison with Time -
I am trying to figure out how to do comparisons with Time. I have been studying VB for about four weeks now and am trying to solve an exercise in one of my books but I can't get any comparison operators to work with time.
When the time is assigned to my Date Time Picker Control I hav
Time Comparison -
i have a time logging system, i m using SQL server 2000 at back end
i have a table named TIME contain a field TimeIN of DATETIME datatype.
login process simple moves the current time in the TimeIN field. now i want to select records within time range. but i failed to write a query f
Workshift problem -
Hi, i have a table with 3 shift settings But i am having problems to identify which shift does the given time belongs to.
Tbl_Shift - ShiftNumber, ShiftStartTime, ShiftEndTime
ShiftNumber is an int. Example 1 for shift 1 , 2 for shift 2 , 3 for shift 3
ShiftStartTime is in datet
Perl Q -
what does shift do???
my $layout = shift;
my $value = shift;
my $forminfo = shift;
my $value_index = shift;
my $x = shift;
my $y = shift;
DTPICKER min,max values -
Please help.
My situation:
Based on a shift of employees:
I am allowing my user to adjust employee's shift end time.
(the Shift Start Time and End Time is determined prior to this screen).
I want to make the Shift End Time MIN to 1/2 hour past the initial end time (z). S
How to find out if it is First, Second or Third Shift: -
How would you code this scenario?
If time is between 5am to 12:59am label1.text = First Shift
If time is between 1am to 6:59am label1.text = Second Shift
If time is between 7am to 2:59pm label1.text = Third Shift
Would you use an IF or a SELECT CASE block and how?
Thanks f
**RESOLVED** IF Time between x and x -
Hello, how would I do the following?
There are 3 shifts with the following times.
7AM to 3PM is 1st shift
3PM and 11PM would be 2nd
11PM and 7AM are 3rd shift
How, by using the system time can I find out what the current shift is?
Time Question, URGENT -
Hi,
I have 3 working shift:
1st shift: 6:00AM-1:59PM
2nd shift: 2:00PM-9:59PM
3rd shift: 10:00PM-5:59AM
How can I be able to know if the current time is either 1st, 2nd or 3rd shift?
the purpose of this question consist in saving activities for each shift into a log witch will be
Date and Time comparison -
Guys,
Heres what i want to do. I have a logging program that records the date and time a process was started and also logs the date and time of when it completed. What i want to do is compare these values to get an elapsed time for the process. Because the logging program writes
Menu Bar in vb.net -
Currently, I am working on menus. If I have a main menu which has submenu. e.g.
View Menu: which has Previous Shift as a submenu. This further has
DateTime of shift 1 : Date and Time of shift1
DateTime of Shift 2 : Date and Time of shift2
DateTime of Shift 3
understanding timespan -
i searched on it, and couldn't come up with anything helpful enough for my particular issue, so will ask the specifics here.
I need to calculate the time difference across midnight, from a given date and time to another given date and time, and based on how long assign a value to it
comparison between ASP and JAVA servlet techonlogy -
Hello All,
Can you give me the comparison between ASP and JAVA servlet techonlogy , i 'm preparing for a presentation i have to describe the diffrence between ASP and JAVA so anybody who knows the above please tell me the same
comparison based on technology , speed, performance
[2005] Declare < > (less/greater than) -
Hi!
How do i declare a less than or greater operator? (if thats the correct wording)
For example:
Code:
Private Sub Compare_Values()
Dim Comparison as _____??
Comparison = <
'// Comparison operator will be a variable set by the user input
'// it will either be le
Shift +F11 Help Needed -
hi
I am Visual Basic 6.0 User.
Actually i need to know Keypress Event
In a run time if i press Shift+F11 then i want set the Flag to 1.
If i press Shift+F11 again i want to set the flag to 0
So how can i acheive this
Depending on the Flag i can continue my wor
Best comparison algorith -
Hello,
Can anyone suggest an algorithm to read a disk file and compare each record to another string?
I was thinking of reading the disk file into a new Collection, then doing a keyed comparison to the other String. Does this sound flakey guys?
My concern is to use a routine t
I want A can Implement press Alt+Shift -
I want to change the direction of writing in textbox by using Alt+Shift Keys. so this will need every time press on these keys, so I want to insert in the texbox's event a code Can Implement Alt+Shift.
SQL Problem!! Help! -
Hi guys,
I have a booking system I'm having trouble with. I think I'm overcomplicating this in my head but if anyone can shed some light, I'd be grateful!
I add a new shift to the system and I need to find all people in the db that aren't already booked at the time the shift
Creating HotKeys -
When I create a hot key for each of the forms in my program only one of the hot keys wordks the key sequences and the corresponding codes passed to windows are:
SHIFT M &h16D
SHIFT E &H145
SHIFT V &H176
SHIFT N &H16E
Am I using the right hex values for each of
Learning and Comparing various Hardware -
Just recently, I've been asked to become computer hardware advisor. I, being a software consultant for most of my life, have virtually no knowledge in computer hardware. Is there any site that compares various brands of printers, scanners, multifunction machines, etc. I'm more concered
Disable Shift+Arrow Key combinations -
I had a search for this, but haven't been able to find a definitive answer. I only want to disable Shift+Arrow Up and Shift+Arrow Down. I only want to do this on one of the events for an MSFlexGrid. I already have a function that will disable shift and mouse clicks but need another
Compare texts strings in VB.NET from Access mdb -
Is there a way I can compare texts strings enter from a user at run time to an Access mdb field declared as memo? If there is a way, would anyone share it with me? The texts typed from a user at run time are from a text box compare to a SQL query from the Access mdb file. If that is no
How to create UDT - for a crew schedule -
Hi
Just out of a matter of interests does anyone have any ideas on
how I could accomplish an automated crew scheduler..
for example
today is 14.04.03 and shift 2 is working but at 22:00 hrs this
will change to shift 3 but at 00:00 the date will change but the
same crew will
Resource Manager - Case Sensitive String Comparison (Resolved) -
Hi there,
I havent posted on this site for quite a while... sorry...
I have a question, is it quicker to perform a case sensitive string comparison rather than a non cases sensitive comparison. I have a resource file that contains quite a few strings, could i optimize access spe
which is greater -
hi all ,
i want to perform comparison between two variable and find out which is greater without using comparison operator.
give me suitable answer,
regards,
abhishek mishra
XML comparison -
Hi,
I have two XML files needed to compare to indicate whether they are same. The comparison focuses on the Data inside the two xml files. the tag sequence could be different.
Thanks for help
Robert
image comparison algorithm -
does anyone know of any image comparison algorithms that can compare two black + white images?
-C
Listview Sort -
Hi all,
I'm trying to sort a list view control, but I don't want it sorted using string comparison.
I know that a callback function can be used for comparison, but I don't seem to be able to make it work.
Some code would be very helpfull, thanks a lot.
Option Compare Database -
I want my database to by default use binary comparison, not text comparison. Anybody know how to do that?
Working with SQL server 2000 / 8.0 -
Hello everyone:
I am using SQL 8.0 Microsoft Technology. My case is as follow:
-- I have three shifts:
First Shift [ 6:00:00 AM TO 13:59:59 PM ] morning to afternoon
Second Shift [ 14:00:00 PM TO 21:59:59 PM ] afternoon to evening
Third shift [ 22:00:00 PM TO 05:59:59 AM ]
Shift Key -
How do i make somthing happen when i hit shift ctrl and r at the same time... i know its like KeyPress or somthing but i dont understand it im a NEWBIE and my VB's MSND isnt working..
I'm Back! - Need Help w/ String Comparison -
Hey Everybody!
Its been a long time since ive been at these forums, but the time of return has finally arrived. I just started doing C++ very recently (in fact, about 4.5 days ago) and I was looking to do string comparison as part of a little beginner project.
My question i
Trap CTRL+F6 (not CTRL+TAB) -
My users want to add hotkey functions to FKeys. They want to use(with others) F6, CTRL+F6, SHIFT+F6 and CTRL+SHIFT+F6.
The CTRL+F6 and CTRL+SHIFT+F6 keys perform next/previous MDI window functions; is there any way for me to trap for CTRL+F6 and CTRL+SHIFT+F6 without also trapping C
How to make an accurate time comparison -
I want to know the elapsed time between two different times as exact as possible.
For example if from Time1 to Time2 difference is 12.75867 seconds
More comparison -
Hi again
Now it's a different type of comparison:
A B C D E F
A B C
I want to get the highest letter in cell A1, that'll say I want the value of D2. But it has to get the value in E2 if the letter D is there and in B2 the letter A.
I've tried with some i
Simple bit comparison routine HELP! -
Could anyone possibly suggest a simple routine / procedure that would take two files and do a complete comparison on a bit to bit basis?
I am VERY rusty with VB, so the simpler the better please!
Many thanks.
Ben.
Access Sum Statement when using Time (RESOLVED) -
Had a look searching for this but not really what i wanted
have this
SELECT *
FROM Production
WHERE Production.Line = 'D4'
AND Production.Shift = 'B'
AND Production.Date = #07/13/04#;
displays
Run Time
01:45
03:30
03:05
01:20
00:45
however when run
SELECT S
Send keys to keyboard -
I am using the sendinput api call and it works great if I send a key to the keyboard, but when I try to send say SHIFT + "n", it will capitalize the N, but the shift stays locked. So the next letter is capitalized too. I have code that presses the key and then unpresses it