Hi, Welcome!
IT & Telecomunications Knowledgebase

Sheets Articles RSS Feed
How do I add hours to a date/time field?
Viewed 113 times since Mon, Oct 31, 2016
Prerequisites The column where date/time is located must be formatted as Date time. Solution In a blank field, type =<date-time-cell>-(<hours>/24) Example to subtract 3 hours: =B2-(3/24) Note If you want to add time, modify the... Read More