Thread: round time in column to nearest half hour
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Dave D-C[_3_] Dave D-C[_3_] is offline
external usenet poster
  
Posts: 176
Default round time in column to nearest half hour
A suggestion:
=CONCATENATE(LEFT(A1,2),":",MID(A1,4,2))
D-C Dave

"J.W. Aldridge" wrote:
I am uploading data, and in column A it post the times like this:
01.31.06
02.00.06
I would like to insert code that would round each time DOWN to the
half hour and then remove the seconds.
01:30
02:00
any suggestions?
thanx

Reply With QuoteReply With Quote