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!!!

 

Daniel

Comments

This discussion has been closed.