Great. And, now we know from the collective knowledge of this mailing list how dates are stored and that there are many good ways to solve this type of problem besides what I suggested. This list is like an ad hoc LO training course.
On Sat, May 7, 2016 at 9:07 AM, John Meyer <john.l.me...@gmail.com> wrote: > This actually worked incredibly well for my problem. > > > > On 5/5/2016 10:52 AM, Bruce Hohl wrote: > >> Try this in cell A2 "=VALUE(A1)*24" >> >> On Thu, May 5, 2016 at 12:44 PM, Russell <ka4...@frontier.com> wrote: >> >> does anyone know if there is a formula for a cell that will transform the >>> HH:mm:ss from another cell into a decimal equivalent? >>> >>> example: >>> >>> Cell A1 has 10:45:20 >>> >>> Cell A2 would change to 10.75 >>> >>> or >>> >>> Cell A1 07:26:15 >>> >>> Cell A2 would change to 7.44 (or round it up 7.5) >>> >>> Thanks >>> >>> Russell >>> >>> >>> >>> -- >>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>> Problems? >>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >>> List archive: http://listarchives.libreoffice.org/global/users/ >>> All messages sent to this list will be publicly archived and cannot be >>> deleted >>> >>> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted