How can I convert an open office cell containing a time value (HH:MM) to a numeric value? I've searched the 'net for a couple hours and can't find an answer. The hours worked was easy =B1-A1 but multiplying that result times a pay rate of $12 doesn't work.