Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    10

    Unanswered: Minutes to Time Conversion?

    I have a field in my database that captures how many minutes past midnight a resource is open. I want to convert minutes past midnight to an actual time. Help?

  2. #2
    Join Date
    Jan 2006
    Posts
    10
    This time has to be displayed as HH:MMS

  3. #3
    Join Date
    Oct 2005
    Posts
    178
    Quote Originally Posted by lewispi
    I have a field in my database that captures how many minutes past midnight a resource is open. I want to convert minutes past midnight to an actual time. Help?
    Play with this.. time and database field involved
    Time(0,0,0) will force the resulting format
    Code:
    Time(0,0,0) + (Time({tblCurrentUsersFS.OUT})-Time({tblCurrentUsersFS.IN}))

Posting Permissions

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