+ Reply to Thread
Results 1 to 5 of 5

UTC time to CST time equation

  1. #1
    Registered User
    Join Date
    05-03-2023
    Location
    Ames, IA
    MS-Off Ver
    Version 16.72
    Posts
    2

    UTC time to CST time equation

    I have tried many different formulas to try to get from UTC time to CST time, and it always gets an error, and I don't know why. Please help!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,158

    Re: UTC time to CST time equation

    It is difficult to debug a picture, but I am unable to replicate your #Value error result. The indicated formulas all work fine for me with a few different inputs.

    My guess is that your time stamps are text and not numbers (they appear to be left aligned in the cell, which is the default for text. Numbers default to right aligned), and there is something about that text string that prevents Excel from automatically recognizing the times and converting them to numbers. The #VALUE error is then an indication that Excel does not know how to add a number to a text string.

    As indicated, we cannot debug a picture. If I were to debug this, I would start with an ISTEXT() function to see if the time stamps are numbers or text. If they are text, I would then work on converting them to numbers. Strategies here for converting text to numbers: https://support.microsoft.com/en-us/...rs=en-us&ad=us

    Once the timestamps are converted to numbers, I would expect your formulas to work without #VALUE errors.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: UTC time to CST time equation

    Are you sure the values in column A are actually valid times rather than strings?

    You can check that using the ISNUMBER function, it will return FALSE if they aren't time values.

    If they do turn out to be strings you could use this formula to convert them to CST,
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    though it would probably be better to convert the entire column from strings to time values.

    To do that select the column, go to Data>Text to columns.., on the third step select Date in the column data format section and click Finish.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    05-03-2023
    Location
    Ames, IA
    MS-Off Ver
    Version 16.72
    Posts
    2

    Re: UTC time to CST time equation

    That worked! Thanks!

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2412
    Posts
    13,613

    Re: UTC time to CST time equation

    sgreeder,
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Dave

+ 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. [SOLVED] Time Conversion Equation
    By boynejs in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2021, 07:55 PM
  2. Replies: 9
    Last Post: 10-16-2020, 04:25 PM
  3. Deactivate a formula or an equation with time
    By saifsawafi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-25-2018, 06:23 AM
  4. Help with a Frost Bite Time Equation
    By boynejs in forum Excel General
    Replies: 5
    Last Post: 02-12-2016, 01:26 AM
  5. Replies: 2
    Last Post: 07-21-2010, 08:59 AM
  6. Hour equation with long date/time
    By caryno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2008, 10:17 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