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
|