| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conitif doesn't recognise time format? how to get round this?
i am tring to get excel to count the number of entries of certain times and a
worksheet. but the format is time eg 06:15 and i want it to look for the number of entries from "06". can anyone help. =countif(mon!$D$3:$D$1500,"06*") is what i have got to so far but its because the details that it is looking at are in time format. I dont want to have to manualy change all the times to text which would work but takes to long. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round/Display (HR:MN:SEC) data in decimal HR format for Time C | Excel Discussion (Misc queries) | |||
| How do I round time | Excel Worksheet Functions | |||
| excel can no longer recognise format | Excel Discussion (Misc queries) | |||
| Round UP Time | Excel Worksheet Functions | |||
| How do I round time? | Excel Worksheet Functions | |||
Threaded Mode
