to add 1 day to a date, just add 1 like this
=A1+1

to add hours to a date, add fractions of a day like this...
=A1+1/24
=A1+2/24
etc.

the function TIME returns the time of day so TIME(24,0,0) results in 0:00 or
0. It shouldn't have added anything at all.

"kknight79558" wrote:

I have a cell formatted with DD/MM/YY HH:MM in 24 hour clock and want to add
1 day or 24 hours. When I use the +time(24,0,0) function the date remains
the same and the hours are only added. How do I get it to add a day to the
date and time. I'm doing time zone convertions for 6 different world
locations.. Tks!