Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
I currently have a field that subtracts the difference between an arrival and
departure time. I have also created an additional 4 fields to see a time frame for the time difference. I placed the formulat =IF(W4<=15,1,0) in the 15 column, but it doesn't seem to be working correctly, just placing a 1 in the columns, regardless if it is over or under 15. I think it has to do with formatting it in proper time format, but don't know how to do that. Can you help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |