.... and the reason for the problem is in Excel help for the TIME() function:
"The decimal number returned by TIME is a value ranging from 0 (zero) to
0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59
(11:59:59 P.M.)."
and
"Hour is a number from 0 (zero) to 32767 representing the hour. Any value
greater than 23 will be divided by 24 and the remainder will be treated as
the hour value. For example, TIME(27,0,0) = TIME(3,0,0) = .125 or 3:00 AM."
--
David Biddulph

"Gary''s Student" wrote in message
...
=A1+1 same format as A1

"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!