Subtract Time
Beautiful, it worked like a baby, to be honest I can't make sense of your
formula but it worked.
While I'm at it, there is one more step I forgot to mention. Once I have
this sollution, (you have enlighted me) now I have to add a column that will
show time added ten minutes.
column "B" minus 30 minutes which I have already
column "C" should be added 10 minutes to column "B"
Thank you
--
smile
"Lars-Åke Aspelin" wrote:
On Mon, 10 Aug 2009 21:03:43 GMT, Lars-Åke Aspelin
wrote:
On Mon, 10 Aug 2009 13:34:01 -0700, israel
wrote:
Hi I have a column "A1" to "A300" with time data (06:19:21), how can I
subtract a half hour? The seconds should not be relevant in the final column.
Thank you
Try the following formula:
=FLOOR(G17-1/48,1/1440)
Hope this helps / Lars-Åke
=FLOOR(A1-1/48,1/1440)
in cell B1
Copy down to cell B300
Lars-Åke
|