Thread: How do I add 24 hours to a date and time value formated cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default How do I add 24 hours to a date and time value formated cell?
In Excel a day is equal to 1, 0.5 is 12 hours and 0.3333 is 8 hours. Simply
add 1 to your cell and that's it.

Time(24,0,0) returns the time on a 24-hour clock, so it is equal to Time(0,0,
0) or 0, which means you added 0 to your cell.

Stephane Quenson.

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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

Reply With QuoteReply With Quote