| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I round hours worked to the next half hour with a 24hr shif | Excel Worksheet Functions | |||
| ... round a time entry to the next "30 minute increment"... | Excel Worksheet Functions | |||
| Round Up to Nearest 10 | Excel Worksheet Functions | |||
| Round Time | Excel Worksheet Functions | |||
| How do I round time? | Excel Worksheet Functions | |||
Linear Mode
