Hi,

I have to fillup cells by VBA with hourly timestamps,
formatted as "DD.MM.YYYY HH" in ascending order. I use the
function

dNew = DateAdd("h", 1, dTimeCount)

where dTimeCount is the old timestamp. The cells in the
worksheet are formatted with "TT.M.JJJJ hh".

When the day changes something is wrong:
.....
22.01.2004 21
22.01.2004 22
22.01.2004 23
22.01.2004 00 <---
23.01.2004 01
23.01.2004 02
.....
Instead of 23.01.2004 00<< the cell value is
22.01.2004 00<< !?

Bug or feature ? And how to deal with this ?

Thanks
Holger