i posted on this one before but got no response.

what i need is a cell that calculates the amount of hours and min. between two cells than returns a value in decmils.

here is what i have in cell h6 =h5-h4.... h5 and h4 are formatted as h:mm am/pm and cell h6 is formated as h:m but when i simpley change this format to 0.00 insted of 8:15 ( 8 hr 15min ) i get a result of .7 when i need 8.25

thanks to those that can help