I have a calc spreadsheet with column A being a date and column B is a time. I am trying to make a foruma that calculates the difference in days and another for the difference in hours between 2 rows.
For example: column A Wed, May 16, 2018 Mon, May 21, 2018 column B 08:30 PM 12:05 PM column C =((A13+B13)-(A12+B12)) =((A14+B14)-(A13+B13))[4.65] column D =TRUNC(C13) =TRUNC(C14) [4] column E - formula? [.65] -- 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
