I want to subtract an end time from the start time to calculate the duration of a task in minutes. For example 4:20 - 4:12 = 8 minutes. Is this possible?
@dminor764 Would be something like this
=(TIME([End Time]@row) - TIME([Start Time]@row)) * 24 * 60
Yes! Thank You! That worked perfect except for when the start time was 12:46 and the end time was 1:10, it then returned 696. Any advice for that?
unfortunately just add AM and PM to your times, lol.
Or you could enter it in military time instead.
I have a filter set so that if this task complete box is checked, then the row is hidden. Is there a way to make it so that if the parent row is checked, then the child rows hide as well? Right now when a parent row is checked, only the parent row is hidden.
Does anyone know why Editor cannot insert columns in a sheet? What's the harm in that? I can see why you might not want someone to delete or rename a column, but inserting a column seems harmless.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.