Adjusting time zone from UK to NZ

Copper Contributor

Morning all

Every 3 days I receive a spreadsheet from England. My country (NZ) is 11 hours ahead.

Am looking for a way to modify the start times of the football games to NZ time and make an adjustment for when the date moves forward a day to NZ time. Screenshot attached.

 

CT_Ahuroa_0-1719611791894.png

Many thanks

1 Reply

@CT_Ahuroa I would just add a column as demonstrated in the picture below.

Screenshot 2024-06-29 at 06.22.09.png

 

All it does is take Date + Time + 11 hours out of a 24 hour day. Make sure the NZ Date/Time is formatted as dd/mm/yyyy hh:mm