I am trying to subtract hours from a time to show the time it is in different time zones depending on where the client is located. I have a team that work in India, but support systems in the USA. I am trying to use an if and match clause so that the time zone can be chosen and depending on the time of year, it will show the correct time. In very simple terms, I have a cell with a time in it: 1:30 AM. I have another cell with the number of hours difference. For example, it is 13.5 hours earlier in the Pacific time zone so that cell says 13.5
I can not subtract 13.5 hours from 1:30 am. I thought the simple formula was a1-a2/24 but that does not come up with the correct time either.