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.