View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kknight79558 kknight79558 is offline
external usenet poster
 
Posts: 1
Default How do I add 24 hours to a date and time value formated cell?

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!