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.
Many thanks
@CT_Ahuroa I would just add a column as demonstrated in the picture below.
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