On 2018-05-24 03:41 PM, Steve Edmonds wrote: > 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. It is hard to enter both a date and time. It is easy to enter "5/24" and it is converted to Mar 24, 2018. > > 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
