View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Converting Hours and Minutes to Just Minutes

The answer depends on the format of your data, and perhaps how the data
is stored. For instance, is it in the format of your example, 1 hr 20
m, contained as text in a single cell? If yes then you'll need to
parse the 1 and the 20 out separately so you can perform the math on
them.

Please post examples of your actual data!