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.
ZULU Hour + 1



Re: ZULU Hour + 1
Hi,
See you have no bites yet so I'm bumping this for you. A macro?

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 
Re: ZULU Hour + 1
A UDF could do it, I think, given an argument for d/m/y an hours...

Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!