| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rouding up times. e.g. 7:33 --> 7:35
I have a clumn of times. How do I round them up to the nearest multiple of 5
minutes? I know of ROUNDUP.. but how do I do it with times? Eg. 5:03 5:05 5:06 5:08 5:09 5:09 5:09 goes to: 5:05 5:05 5:10 5:10 5:10 5:10 5:10 |
|
#2
|
|||
|
|||
|
One way:
=CEILING(A1,"0:5:0") In article , Najeeb wrote: I have a clumn of times. How do I round them up to the nearest multiple of 5 minutes? I know of ROUNDUP.. but how do I do it with times? Eg. 5:03 5:05 5:06 5:08 5:09 5:09 5:09 goes to: 5:05 5:05 5:10 5:10 5:10 5:10 5:10 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
