Please let Smartsheet work with time

Jason Delgado

Sometime when doing sign ups we would like to be able to have a time format the same way we have a date format. It would help for signing up for shifts or would allow for a form that you can enter preferred times. Right now we ask people to use a certain format, but it would be great if it could be required so we don't get 1pm, 1300, 1, and 1:00 from different people on forms.

Thanks.

Kleerfyre

Agree on this! Would help keep the data cleaner and in a uniformed manner.

Joe Goetschel

Time is big, we can already see time in system-generated cells but we really can't use anything but the Date.

There are 2 ways to fix this

1. Allow a column type as Time Then create a net time formula so you can get real data based off am and pm = how many days etc.
2. Modify the date column to use Date and time. (Like the system-generated cells) Again need the formulas to allow proper counting etc.

Use Cases

1. Timesheets
2. PTO
3. call logs
4. Timed Tasks
5. On-call rotations
6. scheduling

Paul Newcome

Built in time calcs would be amazing.

In the meantime... Feel free to check out this post that has a number of time based solutions that will hopefully become obsolete soon.

I have decided to create a post that consolidates all of the different time based solutions that I have put together.<\/p>

Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through these working on making them more efficient and tweaking them, but all of them have been used as working solutions.<\/p>

I thought it would be helpful to have them all in one place instead of spread out.<\/p>

I welcome all feedback, suggestions, and additions.<\/p>

I'll start by posting the published sheets to the solutions. If it is a solution to another community post, it will have a hyperlink to the original post which may help with context. Some are 12 hour clocks and others are 24 hour clocks. Some involve dates and others do not.<\/p>

I will also try to post various tips and tricks as I think of them as well such as:<\/p>

It is easier to convert the hours for 12 hour times to 24 hour times before attempting to do further calculations:<\/p>

=VALUE(LEFT([Time Column]@row, FIND(":", [Time Column]@row) - 1)) + IF(CONTAINS("p", [Time Column]@row), IF(VALUE(LEFT([Time Column]@row, FIND(":", [Time Column]@row) - 1)) <> 12, 12), IF(VALUE(LEFT([Time Column]@row, FIND(":", [Time Column]@row) - 1)) = 12, -12))<\/p>

Calculating Time Worked for Employees<\/a><\/p>

Can you calculate time in Smartsheet?<\/a><\/p>

Conversion of timezones (Solved Formula Included)<\/a><\/p>

Date\/Time\/Year<\/a><\/p>

Flagging a Date and Time Overlap<\/a><\/p>

How do I create time of day columns?<\/a><\/p>

Need to create a "shift" column from a time column<\/a><\/p>","bodyRaw":"[{\"insert\":\"I have decided to create a post that consolidates all of the different time based solutions that I have put together.\\nSome of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through these working on making them more efficient and tweaking them, but all of them have been used as working solutions.\\n\\nI thought it would be helpful to have them all in one place instead of spread out.\\n\\nI welcome all feedback, suggestions, and additions.\\n\\nI'll start by posting the published sheets to the solutions. If it is a solution to another community post, it will have a hyperlink to the original post which may help with context. Some are 12 hour clocks and others are 24 hour clocks. Some involve dates and others do not.\\n\\nI will also try to post various tips and tricks as I think of them as well such as:\\nIt is easier to convert the hours for 12 hour times to 24 hour times before attempting to do further calculations:\\n=VALUE(LEFT([Time Column]@row, FIND(\\\":\\\", [Time Column]@row) - 1)) + IF(CONTAINS(\\\"p\\\", [Time Column]@row), IF(VALUE(LEFT([Time Column]@row, FIND(\\\":\\\", [Time Column]@row) - 1)) <> 12, 12), IF(VALUE(LEFT([Time Column]@row, FIND(\\\":\\\", [Time Column]@row) - 1)) = 12, -12))\\n\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=bde3993a5b7e408e9f112d2049f76662\"},\"insert\":\"Calculating Time Worked for Employees\"},{\"insert\":\"\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=d861f6ccf0e048b98906495ed74671fc\"},\"insert\":\"Can you calculate time in Smartsheet?\"},{\"insert\":\"\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=0122690b7ff744c68653e4dd0fa3cd81\"},\"insert\":\"Conversion of timezones (Solved Formula Included)\"},{\"insert\":\"\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=8b6ddddb66bb4b3db6fbbec745b46795\"},\"insert\":\"Date\\\/Time\\\/Year\"},{\"insert\":\"\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=d39961b785de4312ba2c98b8d148b3bd\"},\"insert\":\"Flagging a Date and Time Overlap\"},{\"insert\":\"\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=e1b1d4c042e84f8b82574cbf378bd767\"},\"insert\":\"How do I create time of day columns?\"},{\"insert\":\"\\n\"},{\"attributes\":{\"link\":\"https:\\\/\\\/app.smartsheet.com\\\/b\\\/publish?EQBCT=54f270e0ed1440f6a25de2453119655c\"},\"insert\":\"Need to create a \\\"shift\\\" column from a time column\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2020-06-08T15:55:08+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/68947\/formulas-for-calculating-time","embedType":"quote","name":"Formulas for Calculating Time"}"> https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

AnBi Logicon

For planning very time senstive project days / milestone days, where we need a runbooke planned by the minutes entering time in hours and minutes would be great

Brooks Alvestad

Create a "time" type column, either am/pm or military time.

Rammie

Hi, I'd like to suggest including a new category type - Time.

A pick list for time (similar to pick list for date) is useful when we run multiple projects with live components. It can surface any conflicts/clashes in scheduling.

Thanks!

bananabender

I use the smartsheet also to log product curing times and shift productivety.

For that it would be great if smartsheet that among the column properties --> column type there would be a time function. That way maybe it will be possible to make a time stamp button in the data collecting forms.

Ken Pavell

It would be very helpful if SmartSheet provided the ability to calculate time variances. This would all for more efficient timesheet calculations or run times calculations for processes tracked in SmartSheet.

Melissa Boehl

Smartsheet has the "Created" column which displays the date and time. However, there is no way to calculate hours/minutes later or before. This is a feature that Excel offers and Smartsheet falls short. I hope that this will change in the near future!!

Brooks Alvestad

Add "Time" as a specific column type.

Sameer K

Some projects and release deployments are time critical and unfortunately Smartsheet does not support date and time format. Appreciate if we can have date-time format supported.

For example, we can have major product release deployment plan with dependencies and with activities durations in hours or mins. Without having the visibility into when the activity starts on a given day and when the next activity starts, it gets difficult to follow the plan.

希望我们可以有类似的,

Task 1 | 1hr | 04/07/23 10:00 AM PST

Task 2 | 2hrs | 04/07/23 11:00AM PST | Dependent on task 1

Task 3 | 30mins | 04/07/23 1:00 PM PST | Dependent on task 2

Adilson Mota

Today I have problems with my smart about recording hours in the database, because as there is no fixed formula for recording hours, production points to other characters, example ; or . or,. with this the graphics are not automatic having to manually correct the notes. We suggest setting up a function similar to data, position when selecting data is the correct format to point. place this field to select the hours and then : will appear and only release the hours and minutes.

Ulises Ars

It would be useful if smartsheet could provide us with a column where we can extract only the time in the sheet or also use as a column configuration to put it in the forms (same as the date).

That is, sometimes I need to measure delivery times, shipments, processes, etc... However, nowadays I have to create 10 columns and configure ten formulas to obtain something similar.

This could also be useful in the HR area when it comes to measuring the time that a collaborator dedicates to his workday or to his productivity.

Jill Freuden

Please add time formatting to Smartsheet's date formatting options. I need to import class schedules and those imports do not import correctly - they import as dates, not times. As a university, the ability to import class schedules is vitally important.

Additionally, time formatting would offer benefits to those attempting to do time reporting calculations in SS. This is a perfect platform to record employee hours, yet it requires a rather complicated formula to make this work. Time formatting would likely be well utilized for this purpose, especially if there were time formulas to go with it.

党卫军已经确认*不进口c的支持orrectly: 06158298 and eventually found documentation that this is a known limitation.

Thank you for the consideration,

Jill Freuden

Waleed

Hi Team

The feature to have column types that include date and time and another column only for time with all automation functions is in need, im waiting for this feature for years and im surprised its not developed yet .

The feature can make the automation way better specially for users who want to create automated workflow at specific time

For example companies ( travel agencies, taxi companies, Call centers or clinics ) who in need to create bookings and reservations for their clients and automation workflow is essential for their bookings and appointments etc .

Last, Smart Sheet members . Please share your ideas and vote for this vote if you need it maybe to grab Production team attention

Thank you ,