Formula to calculate time

ejacksonBPT

Hello. I have a column that is populated like this

I need turn this into total minutes. For instance, the first row 18 H 41 M = 1,121

VBAGuru

A simplistic formula if you always use a 2 digit hour and minute would be:

=value(left([Time]@row,2))*60+value(left(right([time]@row,4),2)

This would require 4 to be entered as 04

ejacksonBPT

hello, what am I doing wrong? It's coming up unparseable.