Question: how to calculate date and time difference in google sheets?
Answer: You can use the TIME function to add or subtract up to 60 seconds: =Start time + TIME(0, 0, N seconds) For example, add 30 seconds: ... 
To calculate over 60 seconds, use simple maths: =Start time + (N seconds / 86400) Add 700 seconds: