Hello Everyone,
I have been referencing the Time calculation post:
How do I create time of day columns? - Smartsheet.com
For some reason the very last formula listed below returns all the minutes as "00" instead of the actual minutes. I am basically copying the formulas listed in the above link except I never have to worry about dates as they will always be the same date.
The formula I am using is for the last column is:
=IF(VALUE(IF(FIND(".", [Time Calc]@row) > 0, LEFT([Time Calc]@row, FIND(".", [Time Calc]@row) - 1), [Time Calc]@row)) < 10, "0") + IF(FIND(".", [Time Calc]@row) > 0, LEFT([Time Calc]@row, FIND(".", [Time Calc]@row) - 1), [Time Calc]@row) + ":" + IF(FIND(".", [Time Calc]@row) > 0, IF(VALUE(RIGHT([Time Calc]@row, LEN([Time Calc]@row) - FIND(".", [Time Calc]@row) + 1)) * 60 < 10, "0" + VALUE((RIGHT([Time Calc]@row, LEN([Time Calc]@row) - FIND(".", [Time Calc]@row) + 1)) * 60, VALUE(RIGHT([Time Calc]@row, LEN([Time Calc]@row) - FIND(".", [Time Calc]@row) + 1)) * 60), "00"))
For example, for the first row my end should come out to be 00:35, or thirty-five minutes. It just seems the minutes are not being calculated correctly. At least for me this is a very complicated formula that I cannot see where it is going wrong. Any help would be appreciated. Honestly, it's surprising Smartsheet hasn't built in a time format yet into the available options for columns.
Thanks in advance!