| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
round time in column to nearest half hour
I am uploading data, and in column A it post the times like this:
01.31.06 02.00.06 02.31.08 03.00.05 03.31.06 04.00.23 04.31.15 05.00.11 05.31.12 06.00.07 I would like to insert code that would round each time DOWN to the half hour and then remove the seconds. 01:30 02:00 02:30 03:00 03:30 04:00 04:30 05:00 05:30 06:00 any suggestions? thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round time down to the nearest half hour? | Excel Worksheet Functions | |||
| how do i round time to the nearest half a minute | Excel Discussion (Misc queries) | |||
| How do I round time to the nearest quarter of an hour | New Users to Excel | |||
| Need to round the time to the nearest quarter hour. Help | Excel Discussion (Misc queries) | |||
| To reformat a culculated date/time round-up to the nearest ½ hour | Excel Programming | |||
Threaded Mode
