ZULU Hour + 1

  • Here's one:

    With a given date (2 digits) and given zulu/UTC hour (also 2 digits), I need a formula, possibly a UDF, that takes the date/time combo and adds 1 hour. Results will go into adjacent cells.

    A1 = date
    A2 = hour(UTC)
    Results into B1 and B2

    If the hour in A2 is 23, then the date in B1 will need to rollover to next day. This may seem simple, but I've run into issues with dates near the end of the month. So date = 31 and hour = 23, the resulting date would not be 32. Any help would be awesome.

  • Re: ZULU Hour + 1


    Hi wxchic:


    If I understand your requirment correctly, the following formula should work.


    For date: IF(B2<0.5,A2,A2+1) - where your date ia A2 and Time in B2


    For time : TIME(HOUR(B2)+1,MIN(B2),0)



    Regards


    Maqbool

  • Re: ZULU Hour + 1


    1. Date cannot be represented in a single cell if it is just two digits. If they are in your case, they are just numbers
    2. Time cannot be represented in a single cell if it is just two digits (unless ONLY hours are represented). If they are in your case, they are just numbers
    2. Adding 23 hours to a date does not change the date

    Please specify what are the contents of A1 and A2 exactly