Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can somebody help please.
I am trying to enter this formula but something does not seem to work. Cell C2 containes a time data in the format HH:MM:SS i am trying to enter in cell D2 the following formula: =IF(C2=03:30:00,"ABC",(C2=04:30:00,"DEF",(C2=05:30 :00,"GHI","FL"))) This does not seem to work with time, though it does work with general numbers. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Calculation | Excel Worksheet Functions | |||
elapsed time calculation | Excel Discussion (Misc queries) | |||
Time calculation. | Excel Worksheet Functions | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions |