On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey Nimmo <[email protected]> wrote: > Sorry, Tanstaafl! > > There is a slight error in the above. The formula should read > =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0) > > 'SEC' is the secant function. Also 'MIN' would also be wrong since it > calculates the minimum of a set of values.
awesome! Thanks very much Harvey! Worked like a charm... -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
