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

Josef Lowder joe at actionline.com
Sun Nov 29 14:09:00 MST 2009


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20091129/2a9d51be/attachment.htm 


More information about the PLUG-discuss mailing list