Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can I use cell history to calculate how much time has taken between two non-date cell types?
Hello SS Community,
I have a sheet that is used by medical professionals. We need to calulate the time between a cell that is filled out when a patient arrives, and one that is filled out when they leave. The cells are text based and not date type, nor are they cells where the user is typing in a time (so I cant simply export and calc in excel).
I can see the time of day in the cell history, is there a way I can calculate the number of hours passed from Cell 1 to Cell 2, if I have time stamps from the cell history. The sheet si aslo too large for this to be a manual process, plus it's a hospital, no one has time for that?!?
thansk in advance, the help is much appreciated!!!