Re: OT: How to convert an open office cell HH:MM to a numeric value?

2009-11-30 Thread Josef Lowder
. Thanks very much Lisa! I sincerely appreciate your very helpful answers to so many questions ... and all of the excellent answers that so many PLUG friends provide. On 11/29/09, Josef Lowder wrote: How can I convert an open office cell containing a time value (HH:MM) to a numeric value?

OT: How to convert an open office cell HH:MM to a numeric value?

2009-11-29 Thread Josef Lowder
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.

Re: OT: How to convert an open office cell HH:MM to a numeric value?

2009-11-29 Thread Lisa Kachold
On Sun, Nov 29, 2009 at 2:09 PM, Josef Lowder j...@actionline.com wrote: 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