time diff (1 Viewer)

  • Thread starter shadowcaster007
  • Start date
S

shadowcaster007

Guest
I am working on a working hours tracking system and I am trying to figure out hours worked in a day. I am using datediff to compare time in and time out. It works great until the time out is after midnight. I get a negative number. Is there a better way to compare times?
I have tried everything I know, please help.

Thanks
 

llkhoutx

Registered User.
Local time
Today, 08:49
Joined
Feb 26, 2001
Messages
4,018
You have to brute force the date rollover.
 

Users who are viewing this thread

Top Bottom