Hi Chris, On 13/01/06, Chris Burton <[EMAIL PROTECTED]> wrote: > If I add 8 hrs to those records with the time after midnight (eg 0:00:25) > for example, starts the day at 8:00:25. But the records with time prior to > midnight (eg 22:15:25 ends up at 30:15:25).
I am not familiar with how Excel handles dates, but two general solutions come to mind. One is to see if Excel can be told that the dates are in UTC or GMT time so that it can do the calculation itself. Alternatively, you know that the hour must be between 0 and 23, thus it adheres to the function MOD(original_hour + 8, 24).
