Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Question Unanswered: How can I subtract time?

    I have to fields which is login and logout and i can't figure a way on how to get the difference of the two. " logout - login"

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    Quote Originally Posted by warriordenz
    I have to fields which is login and logout and i can't figure a way on how to get the difference of the two. " logout - login"
    Make sure your fields data type is date time and here's the formula you need to create. After creating the formula, set the fomat to 24 hour. You can't find this in Crystal Help Section. So save it somewhere for future reference.
    See attached image
    Code:
    Time(0,0,0) + (Time({tblCurrentUsersFS.OUT})-Time({tblCurrentUsersFS.IN}))
    Cool or what!
    Attached Thumbnails Attached Thumbnails time.bmp  
    Last edited by fredservillon; 12-02-05 at 13:12.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •