Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time Calculation | Excel Discussion (Misc queries) | |||
date/time calculation needed | Excel Worksheet Functions | |||
formula date and time calculation | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time/date calculation | Excel Worksheet Functions |