How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is
which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do averages or whatnot. A bigger problem is that my times often cross different days (one common example is length of stay - which I calculate in hours because I have different reporting requirements if that is <24 hours).
The big question is: how do I get a cell to contain a date/time format?
When I import these formulas and data, none of the formulas work, and the date gets dropped from the data stored in the cells.
I'll attach a small example of cells from my Excel workbook so you can see what I mean. Any help is much appreciated. I won't really be able to use Smartsheet if I can't get this to work...which would be really disappointing.