Forum Discussion
Solved
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...
If I understand the goal correctly, subtract 7 hours from received items:
=IF(A2:A8="Received",B2:B8-(7/24),B2:B8)
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!
