Search:

Type: Posts; User: Helen T; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    17,579

    Re: Convert date time from UTC to EST

    Thank you for putting me on the right track!
  2. Replies
    5
    Views
    17,579

    Re: Convert date time from UTC to EST

    I think I have it figured out- Both Column A & B show Date and Time so that portion is already calculated - so I just needed the second formula and it is now correct! thanks again for your...
  3. Replies
    5
    Views
    17,579

    Re: Convert date time from UTC to EST

    I custom formatted by C column with mm/dd/yyyy hh:mm:ss and my results are: 09/26/2133 01:47:14, I am doing something wrong and then C is formatted =A2+B2. I've got a couple of Mr. Excel books that...
  4. Replies
    5
    Views
    17,579

    Convert date time from UTC to EST

    Hello,

    My first post! I am trying to convert spreadsheet from UTC time and date to EST. My formulas for Column C is =MOD(B13-(5/24),1). But for the first 4 rows the time does not convert to...
Results 1 to 4 of 4