Results 1 to 4 of 4

Unable to display Correct Text with Time reference

Threaded View

  1. 01-25-2011, 04:11 PM #3
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Unable to display Correct Text with Time reference

    See attached. You have two problems.

    The biggest problem is that NOW() returns a date + time, not just time. I replaced it with a formula that provides just the time portion.

    The second problem is that you have intervals that start in one day and end the following day. That requires different arithmetic than when you start and stop the same day. See formulas that manage this.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1