Re: [libreoffice-users] difference in hours between two times

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: users+unsubscribe@global.libreoffice.org
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