View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Emily Emily is offline
external usenet poster
 
Posts: 40
Default formula to convert 15 minute to hourly data

Thanks for your help, it works!

"Dave Curtis" wrote:

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