how do i round time to the nearest half a minute
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 |
how do i round time to the nearest half a minute
Hi!
Try this: =ROUND((A1*86400)/30,0)*30/86400 Format as [hh]:mm:ss Biff "Alex" wrote in message ... 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 |
how do i round time to the nearest half a minute
Thanks Biff,
I've just workes it out :-) I used =ROUND(A1/"00:00:30",0)*"00:00:30" Alex "Biff" wrote: Hi! Try this: =ROUND((A1*86400)/30,0)*30/86400 Format as [hh]:mm:ss Biff "Alex" wrote in message ... 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 |
how do i round time to the nearest half a minute
=ROUND(A1*24*60*2,0)/24/60/2
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alex" wrote in message ... 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 |
All times are GMT +1. The time now is 07:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com