Thread: Subtract Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default Subtract Time

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