Thread: formula to convert 15 minute to hourly data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default formula to convert 15 minute to hourly data
Hi again,
Correction to previous reply. To get the time in Column C,
put the following into C2 and drag down.

=IF(MOD(ROW()+2,4)=0,ROUNDDOWN(A2*24,0)/24,"")

Dave

url:http://www.ureader.com/msg/10356248.aspx
Reply With QuoteReply With Quote