date/time calculation

E

eski

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
 
L

Lars-Åke Aspelin

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
 
S

Shane Devenshire

Hi,

If A1 contains the date/time then in A2 enter
10:00
In A3 enter
=A1+A2
 
E

eski

Lars-Ã…ke Aspelin said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top