| View previous topic :: View next topic |
| Author |
Message |
foxy
Power User
Joined: 10 Mar 2005
Posts: 82
|
 Posted: Fri Aug 18, 2006 3:17 am Post subject: Current time in other locations |
 |
|
I need to track the current time in various world cities in my spreadsheet. Something like
Current Time +/- Time Difference
I tried
for example but it displays the date and the time so adding 3 does not change the current time. Can anyone give me some advice how to accomplish it?
_________________
Using Ooo 2.2 on Ubuntu Feisty |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Fri Aug 18, 2006 3:40 am Post subject: Re: Current time in other locations |
|
|
Try =NOW() + 3:00, and format cell as Time 01:37 PM.
David. |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Fri Aug 18, 2006 4:16 am Post subject: |
|
|
You could also add 3/24 and format as David suggests.
_________________
search forum by month |
|
| Back to top |
|
|
foxy
Power User
Joined: 10 Mar 2005
Posts: 82
|
| Posted: Fri Aug 18, 2006 4:59 am Post subject: |
|
|
Thanks a lot!
_________________
Using Ooo 2.2 on Ubuntu Feisty |
|
| Back to top |
|
|
|
