kryptonian
Board Regular
- Joined
- Oct 6, 2006
- Messages
- 104
I am making an attendance template that will record the login/logout time of each employee. Each employee has their own file which is linked to a summary file that collates all the information for all employees.
My problem is that not all workstations are set in the same region. Meaning there are workstations set to PST, some to Mountain, some to Eastern, some Singapore, etc.
What I want to do is to record the login/logout time in a specific time zone (UTC+8:00) regardless of their regional setting.
I am currently using the GetTimeZone code to get the time zone and have this in a cell, say A1. What I would like to have the time in B1 in (UTC+8:00) region. I found out that if I use "=NOW()-(A1/24)+"8:00"" it will work for some regions but not for all possibly because of the NOW() function. How do I go about this?
My problem is that not all workstations are set in the same region. Meaning there are workstations set to PST, some to Mountain, some to Eastern, some Singapore, etc.
What I want to do is to record the login/logout time in a specific time zone (UTC+8:00) regardless of their regional setting.
I am currently using the GetTimeZone code to get the time zone and have this in a cell, say A1. What I would like to have the time in B1 in (UTC+8:00) region. I found out that if I use "=NOW()-(A1/24)+"8:00"" it will work for some regions but not for all possibly because of the NOW() function. How do I go about this?
