N
naga rajan
Consider this example.
A1 - start time
B1 - end time.
C1 - time taken
D1 - alloted time
E1 - status
Consider start time as 9:00:00 and end time as 9:15:30
So the difference is 00:15:30
Alloted time is also 00:15:30
If time taken(C1) is greater than alloted time(D1) i want to print "LATE" in E1.
If C1 is less than D1 then print "EARLY"
If both times C1=D1 then "PERFECT".
The formula I used:
=IF(C1>D1,"LATE",IF(C1<E1,"EARLY",IF(C1=D1,"PERFECT"))).
I get only early or late not perfect when both the times are equal.
Please help out.
A1 - start time
B1 - end time.
C1 - time taken
D1 - alloted time
E1 - status
Consider start time as 9:00:00 and end time as 9:15:30
So the difference is 00:15:30
Alloted time is also 00:15:30
If time taken(C1) is greater than alloted time(D1) i want to print "LATE" in E1.
If C1 is less than D1 then print "EARLY"
If both times C1=D1 then "PERFECT".
The formula I used:
=IF(C1>D1,"LATE",IF(C1<E1,"EARLY",IF(C1=D1,"PERFECT"))).
I get only early or late not perfect when both the times are equal.
Please help out.