Add ten minutes to certain entries in timeseries

[glowfish]

Hi
I am working with a time series of roughly hourly data. The problem is that some of the times are logged ten minutes before the hour (hh:50) instead of on the hour (hh:00). How do I add ten minutes to only the times that are logged ten minutes before the hour. I guess i should use a if , then statement but not sure how to.

Any suggestions??

 

[jasonb75]

Simple way would be

=CEILING(A9,"01:00:00")

 

[Giordano Bruno]

Or

=ROUNDUP(A1*24,0)/24

 

[ramsee]

=+TEXT(IF(MINUTE(A1)>=50,A1+(60-MINUTE(A1))/1440,A1),"hh:mm")

 

[glowfish]

Thanks guys.

Can you also look at my other thread. I'm having trouble with the vlookup function and would appreciate any help.

http://www.mrexcel.com/forum/showthread.php?p=2586852#post2586852