Can this formula be fixed to get the correct time?
I am trying to come up with a formula to track time in Smartsheet. This is the formula I have:
=IF([End Time]@row < [Start Time]@row, ((1200 + [End Time]@row) - [Start Time]@row) * 0.01, (([End Time]@row - [Start Time]@row) * 0.01))
After we hit a certain hour it tacks on 40 extra minutes. Is there a way to fix this formula so that it does not add the extra 40 minutes?
Help Article Resources
Check out the Formula Handbook template!