| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to convert range of time into 1 hour increment
Hi,
I'm working on a report that I need to convert a range of time into only 1 hour increments. Here is an example. A1 Need new cell to show 10:19 AM 10 AM 3:54 PM 3 PM 11:23 AM 11 AM 7:44 AM 7 AM The new cell will not need the minutes, just the hour in which the event occured. I have over 40,000 cells that need to be converted, so anything simple would be great. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time to Half Hour inverval | Excel Discussion (Misc queries) | |||
| Convert time to fraction of an hour | Excel Worksheet Functions | |||
| Convert Time To Half Hour - Pt 2 - OOPS! | Excel Discussion (Misc queries) | |||
| Convert Date/Time to the Hour | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Threaded Mode
