Calculate the time between two dates by days, hours and minutes
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes.
Cell 'O2' being date issued and 'Q2' being date received.
For example: we had a new business request in at say 10:30 on 05/05/2018 we sent out the documents at 12:45 on 10/05/2018. In my new column, the formula would calculate that the time between these two is 5 days, 2 hours and 15 minutes.
So I have a column for the time and date the business came in.
And a column for the time and date the documents were sent out.
I have tried to paste the formula in, and I worked out that you need to use the name of the column in square brackets '[XX]' , instead of cell letters and numbers 'A3'...but everything else i have tried just keeps coming up with '#unparseable'.
I hope that makes sense, can anyone help?
Help Article Resources
Check out the Formula Handbook template!