+ Reply to Thread
Results 1 to 3 of 3

Odd behavior with Time data

  1. #1
    Forum Contributor
    Join Date
    05-12-2009
    Location
    Hendersonville, TN
    MS-Off Ver
    Excel 2010
    Posts
    113

    Odd behavior with Time data

    Hello Forum,

    I am looking for help with a strange time issue I am having on a project of mine. Time values are manually entered into a Userform. The data is pulled to 2 different worksheets. The issue seems to be the time is somehow truncated on the worksheets but fine on the userform. I am sure this is probably something simple I have overlooked, but I am stumped. Attached are some screen shots. One is the Userform with correct time. The other is what is being copied over to my worksheets.

    Thank you for your assistance,

    Patrick
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Odd behavior with Time data

    i think a workbook is required as per the yellow banner, nothing can be determined from screenshots

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Odd behavior with Time data

    try changing the Format Type to Custom with the Type of hh:mm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-16-2014, 12:47 PM
  2. [SOLVED] VBA strange behavior On time events firing at unexpected time intervals.
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2014, 05:58 AM
  3. Some inconsistent behavior in gathering data from internet
    By dnorris707 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2013, 01:29 AM
  4. Excel 2007 : Behavior Data
    By Ukvayat in forum Excel General
    Replies: 2
    Last Post: 09-23-2011, 07:39 AM
  5. Possible to edit Excel behavior for Time entry?
    By Cheopis in forum Excel General
    Replies: 3
    Last Post: 11-05-2008, 04:47 AM
  6. Data Validation Behavior
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2006, 10:40 AM
  7. [SOLVED] Run time error : Excel 2000 and Excel 2003 : different behavior of Macro
    By Bala in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2006, 12:20 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1