Welcome!

Calculating Time into Military Time.

We are Planning a meeting series where everything starts for the day at 08:00 (8AM).

Is there a way to plan out times so that if we say

Meeting Start- 08:00

Opening Remarks – 00:05

Agenda Item 1- 0:15

Agenda Item 2- 0:10

Agenda Item 3- 0:15

And have Smart Sheets total the times at the bottom of the row so we can see quickly WHAT TIME does it end? Like above would End at 08:45

Thanks!

Find more posts tagged with

Comments

Kara Lumley

Hi Ann,

I am able to share you a sheet that may help - a possible solution requires an extra setting to be enabled on your account that will calculate time difference (good for start/end times).

Please send me an email at kara.lumley@smartsheet.com (so that I have your email ) and I will be happy to enable it for you (and anyone else who may need this as well).

Best,

Kara

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet Support Issue
I'm currently having issues with my Smartsheet environment. I pay $72/mo for 3 licenses when I only need one, yet when I have issues my support ticket has remained open for 2 weeks without being assigned. I've looked for help within the community, however when I posted my question a simple response by a random user marked…
Metrics Widget Formatting Issue
Hello, I have created several sheets and reports to be able to live track my progress in a teacher training program. I used a Metric widget to pull the remaining hours from my sheet into a dashboard which works beautifully in the desktop version, but when I look at the mobile version, the formatting is all messed up. I've…
How to avoid duplicate entries while submitting from forms
I want to restrict the duplicate entries in the sheet based on some column value conditions, I can be able to highlight the column but is there any direct method for avoiding duplicates.