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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date/time calculation
On Mon, 29 Dec 2008 23:00:01 -0800, eski
wrote: Can someone please tell me how to add time to a date/time and have the date change accordingly? That is, I’d 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 Add 10/24. If your original date/time is in cell A1 then put the following formuls in another cell to get the wanted date/time: =A1+10/24 Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date/time calculation
Hi,
If A1 contains the date/time then in A2 enter 10:00 In A3 enter =A1+A2 -- If this helps, please click the Yes button Cheers, Shane Devenshire "eski" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date/time calculation
"Lars-Ã…ke Aspelin" wrote: On Mon, 29 Dec 2008 23:00:01 -0800, eski wrote: 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 Add 10/24. If your original date/time is in cell A1 then put the following formuls in another cell to get the wanted date/time: =A1+10/24 Hope this helps / Lars-Ã…ke THANKS MATE |
Reply |
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 |