Hi,

It was some time since you replied to my inquiry and it certainly was very
helpful.

This time around I am required to subtract 31 minutes from the original time.
Since I did not understand the formula I am in a dilema how to work it
around to add the minute.

Just so I am on track with you people, I have column A-1 thru 300 data that
indicates time "6:23:34" now I have to subtract 31 minutes (seconds
irrevelant)

Please reply
Thank you
--
smile


"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