hi, is there a formula like =now() that will get the date and time from a know time source?
Reason is simple. Different people access a shared spreadsheet from different timezones and the =now() returns the user specific time & date from their system.
If we could have an external known time source we could add a few hour to move the time into any given timezone we like. ie we like working in UTC, so if the timezone is ACT we could just calculate it and convert it to UTC, but with =now() this seems impossible.
Thank you.
Reason is simple. Different people access a shared spreadsheet from different timezones and the =now() returns the user specific time & date from their system.
If we could have an external known time source we could add a few hour to move the time into any given timezone we like. ie we like working in UTC, so if the timezone is ACT we could just calculate it and convert it to UTC, but with =now() this seems impossible.
Thank you.