Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=INT(A2*24)/24
and copy down -- __________________________________ HTH Bob "Todd" wrote in message ... 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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Nov 6, 1:15*pm, Todd wrote:
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! Could you convert the format of the cell to custom H? These seems to drop all minutes from mine. Thanks, Jay |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
=TIME(HOUR(A1),0,0) Format as h AM/PM Copy down as needed -- Biff Microsoft Excel MVP "Todd" wrote in message ... 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! |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I dont think it gets much simpler. In B1 enter =a1 drag down Format as hh am/pm Mike "Todd" wrote: 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! |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Bob! I new this had to be simple, but didn't know what to do. 40,000
cells are now converted! "Bob Phillips" wrote: =INT(A2*24)/24 and copy down -- __________________________________ HTH Bob "Todd" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |