The exported activity log for your data room indicates the date and time of each activity carried out by each data room guest.
This date and time will always be shown in the Universal Time Coordinated (UTC) time zone, as this is the primary time standard.
If you wish to convert the UTC time to your local time, you'll need to use this formula in the Excel file:
Your local time zone = (UTC in Column C) +/- (Offset/24)
Let's break it down:
UTC in Column C: This is the UTC date and time in your exported activity log. It should be in Column C of the Excel file.
+/-: Depending on your local time, if you're ahead of UTC, your formula should use the plus sign. If you're behind UTC, your formula should use the minus sign.
Offset: This refers to the difference in hours (plus or minus) between your local time zone and UTC. Find the offset for your local time zone here
24: This refers to the 24 hours in a day.
To give you a few examples:
Eastern time (EST) = (UTC in Column C) - (5/24)
London time (GMT) = (UTC in Column C) - (0/24)
Singapore time (SGT) = (UTC in Column C) + (8/24)
Sydney time (AEDT) = (UTC in Column C) + (11/24)
Do take note of the use of plus and minus signs accordingly.
How to convert UTC to your time zone in Excel
Step 1: Open Excel file for your data room's activity log. Add a column after the Time (UTC) column, which should be in Column C.
Let's use Pacific Standard Time (PST) as an example.
Step 2: Use the formula above to convert the values in the Time (UTC) column to your local time.
For example, for PST, the formula should be = C2 - (8/24). To break it down for you:
C2 refers to Column C, Row 2
Minus sign because PST is behind UTC time
8 because there's an 8-hour difference between PST and UTC
24 for the 24 hours in a day
If you are not in PST, change the formula accordingly to fit your local time zone.
Step 3: Drag the fill handle down the column to convert the UTC dates and times to your local time zone as needed.
Step 4: Don't forget to save your Excel file.
Related links
Still have a question? Or need more help? Drop us a message at support@digify.com.