Roger Govier wrote:
Hi Michael

Time is stored in Excel as fractions of a day (24 hours).
Try =(B1-A1)*24
Format your cell as General, and you should get your expected result.

Regards

Roger Govier


Roger,

SWEET!!! thanks for the heads up. does exactly what I want ( after I
figured out how to apply the round() function to the value as well ).

onto some conditionals now.



michael