Hello, I found this formula to convert time into military time but I would like the formula to be a column formula, so it automatically updates. It looks like I'm not able to convert it from a cell to…
Hello, I am trying to convert total minutes to hours and minutes but am having problems. I am using the formula below, but in some instances it returns a number with 4 digits in the seconds column. =I…
I'm desperate for calculating hours help 😩 I've created a report sheet for incidents in our department. These are submitted using a form and the incidents are managed by several people. The idea is t…
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen …
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. …
Hi guys, I need some help to calculate the hours and minutes have elapsed from a system column (which is the ticket creation date) to the present date, not sure if it is possible to use TODAY() formul…
Hello All, I'm a new user to Smartsheet and am trying to figure out the formula for calculating time. I have a start time column and an end time column and am trying to figure out the formula to calcu…
I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time…
Our internal customers can submit requests to expedite a process to meet a customer's deadline. These requests should be processed within three hours of receipt. Currently, I can add three hours to th…
I am struggling coming up with a time difference calculation smartsheet. I have two text fields, one called From and the other To. Users are to input time in a military format (exp: 07:00, 13:00) and …
