I need to set the scale using vba or vb.net the values are all time values

Secondly the uppermost value has to be 24:00 excel simply goes on and on

Any help would be welcome

pdfrone