| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
I have a column that houses a time. The column may have 2000 rows. I would
like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement
Try this instead
=HOUR(A2) &":00 to "& HOUR(A2) &":59" Drag down Mike "khicks4u" wrote: I have a column that houses a time. The column may have 2000 rows. I would like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement
=TEXT(TIME(HOUR(A2),0,0),"hh:mm")&" to "&TEXT(TIME(HOUR(A2),59,0),"hh:mm")
Regards, Stefi €˛khicks4u€¯ ezt Ć*rta: I have a column that houses a time. The column may have 2000 rows. I would like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement
You are a life saver Mike!!!!! Thank you that worked. Is there a way I can
get the format to be 01:00 to 01:59 instead of 1:00 to 1:59? "Mike H" wrote: Try this instead =HOUR(A2) &":00 to "& HOUR(A2) &":59" Drag down Mike "khicks4u" wrote: I have a column that houses a time. The column may have 2000 rows. I would like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement
=HOUR(--TEXT(A2,"00\:00"))&":00 to "&HOUR(--TEXT(A2,"00\:00"))&":59"
or =INT(A2/100)&":00 to "&INT(A2/100)&":59" -- David Biddulph "khicks4u" wrote in message ... I have a column that houses a time. The column may have 2000 rows. I would like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement
Yes,
=TEXT(TIME(HOUR(A2),0,0),"hh") &":00 to "& HOUR(A2) &":59" Mike "khicks4u" wrote: You are a life saver Mike!!!!! Thank you that worked. Is there a way I can get the format to be 01:00 to 01:59 instead of 1:00 to 1:59? "Mike H" wrote: Try this instead =HOUR(A2) &":00 to "& HOUR(A2) &":59" Drag down Mike "khicks4u" wrote: I have a column that houses a time. The column may have 2000 rows. I would like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement
Hmmm,
That doesn't work and I just noticed Stefi has posted a solution. Mike "Mike H" wrote: Yes, =TEXT(TIME(HOUR(A2),0,0),"hh") &":00 to "& HOUR(A2) &":59" Mike "khicks4u" wrote: You are a life saver Mike!!!!! Thank you that worked. Is there a way I can get the format to be 01:00 to 01:59 instead of 1:00 to 1:59? "Mike H" wrote: Try this instead =HOUR(A2) &":00 to "& HOUR(A2) &":59" Drag down Mike "khicks4u" wrote: I have a column that houses a time. The column may have 2000 rows. I would like to enter an IF statement in the column next to it to identify what hour this time falls into, but can it handle 24 possibilities? Time Result 1330 13:00 to 13:59 1615 16:00 to 16:59 2020 20:00 to 20:59 Thanks Kem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
