Question about total time formula

Options

Good Afternoon! I am successfully using the following formula to calculate total time from a start and end date and time:

=((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) + ([End Date]@row - [Start Date]@row) * 24) - (VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) + VALUE(RIGHT([Start Time]@row, 2)) / 60)

The guys using the sheet want me to take the : out of the time and change to an all numbers format (0600 vs. 06:00). I don't want to mess up my formula. Any ideas on how to make that change and still have the formula calculate total time? Thanks in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!