Forum Discussion

sguzman0023's avatar
sguzman0023
Copper Contributor
Nov 14, 2023

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 timestamp...
Excel
Formulas and Functions
office 365
  • Patrick2788's avatar
    Patrick2788
    Nov 14, 2023

    sguzman0023 

    If I understand the goal correctly, subtract 7 hours from received items:

     

    =IF(A2:A8="Received",B2:B8-(7/24),B2:B8)

     

sguzman0023's avatar
sguzman0023
Copper Contributor
Nov 14, 2023
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.