Subtract Hours in Smartsheet
Is there a way in Smartsheet, like in Excel, that you can subtract hours and convert PM to AM? I have a "KO time" column, and a "Start Time" column, and I am wanting to subtract 5 hours from the KO time column to have my "Start Time".
The formula I have in excel does not work in smartsheets (="KO Time"-(5/24)) and I am trying to migrate this sheet from excel to smartsheets
Help Article Resources
Check out the Formula Handbook template!