I am trying to get minutes only from a time value.
I initially assumed I could do:
But this returnes the wrong value.
I looked at the Text() documentation and found:
Displays the minute as a number with a leading zero when appropriate. Note: The m or the mm placeholder must appear immediately after the h or hh placeholder or immediately before the ss placeholder. Otherwise, Text returns the month instead of minutes.
This suggests it is not possible to return only minutes from a date or time function.
Most functions to format timevalues provide 'MM' insetad of 'mm' for minutes.
So far the only way I have found to return only the minues is this:
There must be a simpler way to return just minutes without having to trim strings.