Results 1 to 2 of 2
  1. #1
    Eranka is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    150

    Time In Thread

    Hi Please see below image


    Click image for larger version. 

Name:	Untitled.jpg 
Views:	15 
Size:	10.2 KB 
ID:	32644

    Total accepted hours is in time format. when i show the result in a report it gives me the correct value for less than 24 hours. but anything above 24 hrs it does not give the value. it should be 32:34 instead it gives me the value 7:34 how to solve this?

    one formula i used was
    =IIf([SumOfAccepted_Hours]<24,[SumOfAccepted_Hours],[Expr1])

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    The answer's given here https://www.accessforums.net/showthr...285#post383285 for the same question will work.
    Have you not tried it?

    As described in the other thread a time value cannot be valid if it's over 24:00 - that is not a valid time.
    You have to format the total number as a string or store the total minute value and format it to display it as if it was hours and minutes - again described in the other thread.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to mark a thread as solved
    By Matrix in forum Forum Suggestions
    Replies: 10
    Last Post: 12-12-2019, 06:55 AM
  2. How do you mark a thread as solved?
    By JonathanT in forum Access
    Replies: 1
    Last Post: 07-20-2016, 03:22 PM
  3. forum thread locking - why?
    By CJ_London in forum General Chat
    Replies: 1
    Last Post: 07-02-2015, 12:09 PM
  4. How do I find an old thread I created?
    By nancyma in forum General Chat
    Replies: 2
    Last Post: 02-13-2014, 01:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums