| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
