DUR2MINUTES

The DUR2MINUTES function converts a duration value to a number of minutes.

DUR2MINUTES(duration)

duration: The length of time (duration value) to be converted.

Examples

=DUR2MINUTES(“2w3d2h10m0s5ms”) returns 24,610.0000833333.

=DUR2MINUTES(“10:0:13:00:05.500”) returns 101,580.091666667.

See also
DUR2DAYS
DUR2HOURS
DUR2MILLISECONDS
DUR2SECONDS
DUR2WEEKS