Forum Discussion
Help please! ASAP!
Hi, I'm creating a spreadsheet of calls, messages, recordings, etc., for a court case. Unfortunately, because I use Samsung and the contacts I need to document are iPhone users, none of the timestamps match up correctly. When I compare with my phone to my spreadsheet, it matches. The iPhone users are 7 hours ahead in time. How can I subtract these 7 hours to match my local timezone? This is the format I'm using. Notice I send at 15:19/15:20 but it shows 7 hours later as the receiving response is at 22:20. Thanks for the help.
Steve Guzman
| Received | 8/4/2023 22:20 |
| Received | 8/4/2023 22:20 |
| Received | 8/4/2023 22:15 |
| Received | 8/4/2023 22:02 |
| Sent | 8/4/2023 15:20 |
| Sent | 8/4/2023 15:19 |
| Sent | 8/4/2023 15:19 |
Keep in mind i already separated the wrong time zone cells to another tab so i can correct the times, and then i will move it back and combine them.
If I understand the goal correctly, subtract 7 hours from received items:
=IF(A2:A8="Received",B2:B8-(7/24),B2:B8)
- Keep in mind i already separated the wrong time zone cells to another tab so i can correct the times, and then i will move it back and combine them.
If I understand the goal correctly, subtract 7 hours from received items:
=IF(A2:A8="Received",B2:B8-(7/24),B2:B8)- Amazing! ty very much for the help
- You're welcome!
