I have a bunch of time cells in a spreadsheet. I'm trying to offset them all by a specific time interval, say 30 minutes or 1 hour. I don't want to offset these time values in cells elsewhere. I want the cells containing the old values to be replaced by the new values. Is there a way to do this?
PS: I use google sheets so would appreciate if you could give a solution with regards to that platform. Not an issue otherwise, I'll try to replicate the functionality myself. Thanks in advance.