Is there a reason you can't put A and B in one column. Format cell as date, define the format DDD MMM DD YYYY HH:MM AM/PM You can then subtract easily and result is in days or x 24 for hours.
Steve On 25/05/18 07:07, James wrote:
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
