Hi there! I would like to use General Caster to take the Date + Time in a Date column and ADD the value of a Numbers column (in this case, value is hours) and cast the result to another column - presenting the result as either Text or Date + Time.
ie. Date column says Jan 24, 2021 with time as 9:00am. Numbers column says 7. I want to cast the result of Date & time + Numbers and cast that result to a column called ‘Estimated Loading Date’.
In Excel/Google Sheets I would typically use the formula: cell + cell/24 to show the resulting date & time.
Looking for help!