View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eski eski is offline
external usenet poster
 
Posts: 2
Default date/time calculation

Can someone please tell me how to add time to a date/time and have the date
change accordingly? That is, Id like to add 10 hours to a GMT date/time. For
example, if I have the date/time of: 28 Dec. 2008 7:00PM GMT€¦how do I get it
to 29 Dec 2008 5:00AM to reflect Sydney time?

Many thanks