ot;")"
Last formula only needs the one cell, but if it is just to display, looks nice.
On 25 May 2018 at 1:21, James wrote:
From: James <bjloc...@lockie.ca>
To: "Michael D. Setzer II" <msetze...@gmail.com>
Date sent:
rote:
> >
> > To: users@global.libreoffice.org
> > From: James <bjloc...@lockie.ca>
> > Subject:[libreoffice-users] difference in hours
> > between two
> > times
> > Date sent: Thu, 24 May 201
:07, James wrote:
To: users@global.libreoffice.org
From: James <bjloc...@lockie.ca>
Subject: [libreoffice-users] difference in hours between two
times
Date sent: Thu, 24 May 2018 15:07:15 -0400
I have a calc spreadsheet with
) '=C1/24
On 24 May 2018 at 15:07, James wrote:
To: users@global.libreoffice.org
From: James <bjloc...@lockie.ca>
Subject: [libreoffice-users] difference in hours between two
times
Date sent: Thu, 24 May 2018 15:07:15 -040
Is there a reason you can't put A and B in one column.
Format cell as date, define the format DDD MMM DD 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
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