| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find out a time
I have a column with the format of custom hh:mm. As you can guess its a list
of times. In another column I want to have a 0 if the time is not between 8am and 6pm and and a 1 if it is. How can i do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find out a time
Keith,
Put this alingside your first time and drag down:- =IF(AND(A1TIME(8,0,0),A1<TIME(18,0,0)),1,0) Mike "Keith" wrote: I have a column with the format of custom hh:mm. As you can guess its a list of times. In another column I want to have a 0 if the time is not between 8am and 6pm and and a 1 if it is. How can i do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find out a time
=--AND(A1=--"08:00",A1<=--"18:00")
or (if the column might be date & time, formatted to show just the time) =--AND(MOD(A1,1)=--"08:00",MOD(A1,1)<=--"18:00") -- David Biddulph "Keith" wrote in message ... I have a column with the format of custom hh:mm. As you can guess its a list of times. In another column I want to have a 0 if the time is not between 8am and 6pm and and a 1 if it is. How can i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| How do I find more than two digits at the same time? | Excel Worksheet Functions | |||
| How do I find the average time? | Excel Worksheet Functions | |||
| I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps | Excel Discussion (Misc queries) | |||
| How can i find time in various time zone? | New Users to Excel | |||
Linear Mode
