Calculate amount of hours between dates and times

Leah Taylor

Hello,

Can anyone help me calculate the amount of hours and minutes between dates and times? I have tried numerous formulas but none are working for me. Is there any particular format the time column needs to be?

Appreciate anyone's help with this, thank you.

Leah

Paul Newcome

It might take a little bit of digging (up to 14 pages at this point), but there should be something tucked away in here for you:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Leah Taylor

Thank you very much, that is helpful.

this one is working for me, only thing is i want it to include working hours only, is this possible?

Leah Taylor

@Paul Newcome can you offer any help on the above?

Thank you

Joe Goetschel

Time is so frustrating... I wish I had something to help! I can share this to Vote on for feature requests.

Please let Smartsheet work with time — Smartsheet Community

Leah Taylor

Thanks! @Joe Goetschel