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

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: 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