is it possible?? e.g. i have a list of times 01:05:28 round to 01:05:30 01:05:45 round to 01:06:00
A Alex Sep 25, 2006 #1 is it possible?? e.g. i have a list of times 01:05:28 round to 01:05:30 01:05:45 round to 01:06:00
B Bob Phillips Sep 25, 2006 #2 =ROUND(A1*24*60*2,0)/24/60/2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=ROUND(A1*24*60*2,0)/24/60/2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
