Sure, I can help you with that! You can use the following formula to subtract 5 hours from the time stamp in
Column G:
- =G2-TIME(5,0,0)
This formula uses the
TIME function to subtract 5 hours (represented as 5,0,0) from the time stamp in cell G2. You can then copy this formula down the column to apply it to all the cells in the column.
Alternatively, you can use the following formula to subtract 5 hours from the entire date/time value in
Column G:
- =G2-5/24
This formula divides 5 by 24 (since there are 24 hours in a day) to convert 5 hours to a decimal value, and then subtracts that value from the date/time value in cell G2. Again, you can copy this formula down the column to apply it to all the cells in the column.