Macro to Work Around 32767 Limit

[opsanalysis07]

Hello all,

I am trying to see if there is a macro I can write to work around the 32767 16-bit limitation. In the attached file I have two time columns given as my primary data inputs (Column A and Column B). Column A is an elapsed time column in fractions of an hour, the second column is a corresponding DateTime (called ClockTime). I want to add the elapsed time to the DateTime, which I can do by converting each elapsed time to seconds by multiplying by 3600, converting those values to a time by using the TIME(0,0,##) function and then adding each elapsed time to the very first DateTime, but the formula breaks down after 32767. Is there a macro or just a regular formula I can write to work around this? Any help is appreciated, thank you.

[shg]

Not seeing the problem ...

	A	B	C	D
32771	9.1025	9/28/2016 17:06	9/29/2016 2:12	C32771: =A32771/24 + B32771
32772	9.102777778	9/28/2016 17:06	9/29/2016 2:12
32773	9.103055556	9/28/2016 17:06	9/29/2016 2:12
32774	9.103333333	9/28/2016 17:06	9/29/2016 2:12
32775	9.103611111	9/28/2016 17:06	9/29/2016 2:12

[opsanalysis07]

Well, because apparently there isn't one anymore. No idea why that wouldn't work for me before but I appreciate the assist.

[shg]

You're welcome.