=A1+1 same format as A1
--
Gary''s Student - gsnu200738


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