Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 30th, 2007, 03:58 AM
Friend of Wrox
 
Join Date: Jan 2006
Location: Hardwar, Uttranchal, India.
Posts: 180
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via ICQ to dpkbahuguna Send a message via MSN to dpkbahuguna Send a message via Yahoo to dpkbahuguna
Default Time Shift Logic !!!

hello Friends!!!

  Can anyone help me here...its very urgent..
  I am working for PayRoll system..
  But I am stuck suddenly..in attandence module..

  There is a shift time which switched to next day..

  Like : 2030 to 0500

  and user can Punch anytime and there is no limit of punching..
  and I have to find out that which one in InTime and which one is
  OutTime.

  I have done all the rest Three shifting..but stuck with this one.

  anyone can give me Idea pls.....

  Thank you very much!!!

DPK..
__________________
DPK..
 
Old August 30th, 2007, 05:06 PM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

You should be able to get the time differential, despite crossing into the next day. Set a baseline at 2030, and look at all the time differentials from that time. Set ins and outs through comparing the relative magnitude of the differentials.
 
Old August 30th, 2007, 11:52 PM
Friend of Wrox
 
Join Date: Jan 2006
Location: Hardwar, Uttranchal, India.
Posts: 180
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via ICQ to dpkbahuguna Send a message via MSN to dpkbahuguna Send a message via Yahoo to dpkbahuguna
Default

Quote:
quote:Originally posted by BrianWren
 You should be able to get the time differential, despite crossing into the next day. Set a baseline at 2030, and look at all the time differentials from that time. Set ins and outs through comparing the relative magnitude of the differentials.
Thanks for you Reply Brian...

   Can you give me hint pls how can I differentiate the time like..

   difference between these : (2030 to 0530)

  thanking again and waiting for you reply..




DPK..
 
Old August 31st, 2007, 11:56 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Code:
?DateDiff("h",  CDate("12/12/07 11:00 PM"), CDate("12/13/07 1:00 AM"))
 2




Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Shift time in minus time out lechalas Beginning VB 6 1 August 11th, 2008 01:56 PM
Time shift logic ADVANCED-plz help zrtv Beginning VB 6 5 September 17th, 2007 02:08 AM
shift from vb to c# noman77 .NET Framework 2.0 1 October 14th, 2004 08:15 AM
Shift + Enter OR Shift+Double-Click phungleon Access 2 May 20th, 2004 10:14 AM
Mixing Data access logic and business logic polrtex BOOK: Professional Jakarta Struts 0 December 15th, 2003 07:19 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.