How to calcualate time difference

Finops C'ship

Finops C'ship ✭✭

10/21/21 in Formulas and Functions

Hi Team,

How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM

Regards,

Tags:

0 ·

Answers

Parker Oxford ✭✭✭✭✭

10/21/21 edited 10/21/21

This thread may be useful for you.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a way to stop automations when the person being notified is the person that trig
Is there a way to stop automations when the person being notified is the person that triggered said automation?
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…